DataBase Management System (DBMS) solved MCQs

chapters
1 of 57

1. Where is metadata stored in MySQL?

a. in the mysql database meta

B. in the mysql database metasql

c. in the mysql database metadata

d. in the mysql database mysql

2. What MySQL property is used to create a surrogate key in MySQL?

a. identical

B. unique

c. auto_increment

d. sequence

3. A relational database consists of a collection of

a. keys

B. records

c. tables

d. fields

4. A Database Management System (DBMS) is:

a. collection of data describing one particular enterprise

B. collection of programs to access data

c. all options are correct

d. collection of interrelated data

5. Which of the following is not a level of data abstraction?

a. view level

B. physical level

c. logical level

d. critical level

6. Disadvantages of File systems to store data is:

a. data isolation

B. data redundancy and inconsistency

c. difficulty in accessing data

d. all options are correct

7. In an Entity Relationship Diagram Rectangles represents

a. tables

B. attributes

c. database

d. entity sets

8. Which of the following is not a Storage Manager Component?

a. transaction manager

B. logical manager

c. file manager

d. buffer manager

9. Data Manipulation Language enables users to

a. retrieval of information stored in database

B. insertion of new information into the database

c. deletion of information from the database

d. all the options are correct

10. Which of the following is not an Schema?

a. logical schema

B. physical schema

c. database schema

d. critical schema

11. Which of the following is Database Language?

a. data definition language

B. data manipulation language

c. data query language

d. all of the options

12. Which of the following in not a function of DBA?

a. network maintenance

B. schema definition

c. authorization for data access

d. routine maintenance

13. Which of the following is a Data Model?

a. entity relationship model

B. object based data model

c. all of the options are correct

d. relational data model

14. A Database Management System (DBMS) is

a. collection of interrelated data

B. collection of data describing one particular enterprise

c. all of the options

d. collection of programs to access data

15. Which of the following is not a level of data abstraction?

a. physical level

B. view level

c. critical level

d. logical level

16. Disadvantages of File systems to store data is:

a. data redundancy and inconsistency

B. data isolation

c. all of the options

d. difficulty in accessing data

17. Which of the following is not a Storage Manager Component?

a. transaction manager

B. buffer manager

c. file manager

d. logical manager

18. Data Manipulation Language enables users to

a. retrieval of information stored in database

B. deletion of information from the database

c. all of the above

d. insertion of new information into the database

19. Which of the following is not an Schema?

a. logical schema

B. critical schema

c. database schema

d. physical schema

20. Which of the following is Database Language?

a. all of the options

B. query language

c. data definition language

d. data manipulation language

21. Which of the following in not a function of DBA?

a. authorization for data access

B. network maintenance

c. routine maintenance

d. schema definition

22. Which of the following is a Data Model?

a. object-based data model

B. all of the options

c. entity-relationship model

d. relational data model

23. Column header is refer as

a. table

B. domain

c. attributes

d. relation

24. _______ allow us to identify uniquely a tuple in the relation.

a. schema

B. superkey

c. domain

d. attribute

25. Minimal Superkeys are called

a. schema keys

B. attribute keys

c. candidate keys

d. domain keys

Tags

Question and answers in DataBase Management System (DBMS),

DataBase Management System (DBMS) Multiple choice questions and answers,

Important MCQ of DataBase Management System (DBMS),

Solved MCQs for DataBase Management System (DBMS),

DataBase Management System (DBMS) MCQ with answers PDF download