Database management system

1. What is the primary purpose of a database system?

a) To store data in a structured format b) To provide a platform for data sharing and integration c) To ensure data security and integrity d) All of the above

2. Which of the following is NOT a component of a DBMS?

a) Query Processor b) Storage Manager c) Transaction Manager d) Web Server

3. What is the role of the Query Processor in a DBMS?

a) To manage data storage and retrieval b) To optimize and execute user queries c) To handle transaction management d) To enforce data security

4. Which component of a DBMS is responsible for managing data storage?

a) Query Processor b) Storage Manager c) Transaction Manager d) Data Dictionary

5. What is the purpose of the Transaction Manager in a DBMS?

a) To ensure data consistency and integrity b) To optimize query execution c) To manage user authentication d) To store metadata

6. Which of the following is a feature of DBMS architecture?

a) Data Independence b) Centralized Control c) Data Redundancy d) Data Inconsistency

7. What is Data Independence in DBMS?

a) The ability to store data in multiple formats b) The separation of data from application programs c) The ability to access data without a DBMS d) The ability to store data on multiple servers

8. Which type of Data Independence allows changes in the physical storage without affecting the logical schema?

a) Logical Data Independence b) Physical Data Independence c) Structural Data Independence d) Operational Data Independence

9. Which type of Data Independence allows changes in the logical schema without affecting application programs?

a) Logical Data Independence b) Physical Data Independence c) Structural Data Independence d) Operational Data Independence

10. Which of the following is a characteristic of a DBMS?

a) Data Redundancy b) Data Inconsistency c) Data Sharing d) Data Fragmentation

11. What is the primary function of the Data Dictionary in a DBMS?

a) To store metadata about the database b) To manage user queries c) To enforce data security d) To handle transaction management

12. Which of the following is a disadvantage of using a DBMS?

a) Improved data security b) Increased complexity c) Reduced data redundancy d) Enhanced data integrity

13. Which of the following is a benefit of using a DBMS?

a) Data Redundancy b) Data Inconsistency c) Data Integrity d) Data Fragmentation

14. What is the purpose of the DBMS Architecture?

a) To define the structure and organization of the database system b) To manage user authentication c) To optimize query execution d) To store metadata

15. Which of the following is a type of DBMS Architecture?

a) Single-Tier Architecture b) Two-Tier Architecture c) Three-Tier Architecture d) All of the above

DBMS MCQs

Your Score: /15