Quiz on Introduction to DBMS

1) A database is a collection of:

2) Raw facts and figures are called:

3) Processed or organized form of data is called:

4) Which of the following is an example of data?

5) Which of the following is an example of information?

6) DBMS stands for:

7) Which of the following is NOT an example of DBMS software?

8) Which of the following is an example of DBMS?

9) The software used to create, update and retrieve data is called:

10) Which of the following is NOT an advantage of DBMS?

11) Repetition of same data in multiple places is called:

12) When the same data is stored differently in different tables, it leads to:

13) Translating data in such a manner that unauthorized users cannot read it is called:

14) The structure of a database that describes how data will be stored and retrieved is called:

15) Which of the following is a type of data model?

16) In the Hierarchical Data Model, data is organised in:

17) In the Network Data Model, multiple records are linked to:

18) The Relational Data Model is based on the principle of:

19) The Relational Database Model was proposed in 1970 by:

20) The most commonly used database model is:

21) A real-world object about which information is stored in a database is called:

22) The details associated with an entity are called:

23) In a relational database, a row represents:

24) In a relational database, a column represents:

25) A collection of logically related records organized as columns and rows is called:

26) The smallest entity in the database is:

27) A collection of fields makes a:

28) A collection of records makes a:

29) A collection of tables makes a:

30) A field that uniquely identifies each record in a table is called:

31) Which of the following statements about a primary key is TRUE?

32) A primary key field:

33) If more than one field is used to uniquely identify a record, it is called:

34) A field in one table that refers to the primary key of another table is called:

35) A foreign key is used to:

36) All field values eligible to be a primary key are called:

37) The candidate key that is not selected as the primary key is called:

38) Which of the following is NOT an object of RDBMS?

39) A user-friendly data entry screen in DBMS is called:

40) Which RDBMS object is used to retrieve specific data from the database?

41) Which RDBMS object is used to present retrieved data in a formatted and printable manner?

42) In a database, an entity “Student” can have which of the following attributes?

43) Data values are the raw data represented in:

44) A relational database is:

45) Which advantage of DBMS ensures that data retrieval is fast and accurate?

46) In a student table with fields Roll_No, Name, Class, and Marks, the most suitable primary key would be:

47) Which of the following can help check whether valid data is being entered?