This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 36 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 36 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the primary function of the storage manager in a DBMS? A) To enforce data security. B) To create user interfaces. C) To process user queries. D) To manage data storage and retrieval. Show Answer Correct Answer: D) To manage data storage and retrieval. 2. What is a safe expression in relational calculus? A) Has no variables. B) Generates infinite relations. C) Uses only known values. D) Is always true. Show Answer Correct Answer: C) Uses only known values. 3. What is the output when the data "FOREIGN key' is set to the text format > in Access? A) Foreign key. B) FOREIGN KEY. C) Foreign Key. D) Foreign key. Show Answer Correct Answer: B) FOREIGN KEY. 4. When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 5. What is the purpose of SQL in database management? A) The purpose of SQL in database management is to manage and manipulate relational databases. B) To visualize data in spreadsheets. C) To create non-relational databases. D) To perform statistical analysis on data. Show Answer Correct Answer: A) The purpose of SQL in database management is to manage and manipulate relational databases. 6. In a database for a hospital, there are separate tables for 'Patients', 'Doctors', and 'Appointments'. If a query is run to find a patient's diagnosis, what type of database architecture component is being used to retrieve that specific information for the user? A) The internal schema. B) A conceptual schema. C) An external schema. D) A database instance. Show Answer Correct Answer: C) An external schema. 7. What is the purpose of the query processor in a DBMS? A) To interpret and execute database queries. B) To manage file storage. C) To remove redundant data. D) To create new databases automatically. Show Answer Correct Answer: A) To interpret and execute database queries. 8. What does a composite key consist of? A) Two or more columns. B) One column. C) No columns. D) A single value. Show Answer Correct Answer: A) Two or more columns. 9. Which component of a DBMS is responsible for converting user queries into instructions the database can execute? A) Data dictionary. B) Query processor. C) Report generator. D) Backup manager. Show Answer Correct Answer: B) Query processor. 10. List the types of data models commonly used in DBMS. A) Columnar. B) Key-Value. C) Flat File. D) Hierarchical, Network, Relational, Object-Oriented, Document. Show Answer Correct Answer: D) Hierarchical, Network, Relational, Object-Oriented, Document. 11. A database is in BCNF but still has redundancy. What could be the possible reason? A) It still contains transitive dependencies. B) It has overlapping candidate keys. C) It lacks a foreign key constraint. D) It does not have a primary key. Show Answer Correct Answer: B) It has overlapping candidate keys. 12. Define normalization and its importance in database design. A) Normalization is the process of combining all data into a single table. B) Normalization is only necessary for large databases. C) Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. D) Normalization increases data redundancy and decreases performance. Show Answer Correct Answer: C) Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. 13. What is the main function of the query processor? A) To ensure data security. B) To create user interfaces. C) To manage data storage. D) To interpret and execute database queries. Show Answer Correct Answer: D) To interpret and execute database queries. 14. How can ER diagrams be extended to include more complex relationships? A) ER diagrams cannot include attributes for entities. B) ER diagrams can include weak entities, ternary relationships, and generalization/specialization. C) ER diagrams are limited to one-to-one relationships only. D) ER diagrams can only represent binary relationships. Show Answer Correct Answer: B) ER diagrams can include weak entities, ternary relationships, and generalization/specialization. 15. Which key uniquely identifies a record? A) Foreign key. B) Primary key. C) Candidate key. D) Composite key. Show Answer Correct Answer: B) Primary key. 16. The internetworked organizational databases at different sites to be integrated and synchronized with all the facilities of database approach is ..... A) Centralized database. B) Distributed database. C) Localized database. D) Globalized database. Show Answer Correct Answer: B) Distributed database. 17. What is the purpose of a data model? A) To create visual representations of data only. B) To store data without any structure. C) To eliminate the need for data analysis. D) The purpose of a data model is to represent and organize data in a structured way to support data management and analysis. Show Answer Correct Answer: D) The purpose of a data model is to represent and organize data in a structured way to support data management and analysis. 18. What does a primary key do? A) Allows duplicates. B) Identifies records uniquely. C) Stores data. D) Links tables. Show Answer Correct Answer: B) Identifies records uniquely. 19. What are the limitations of a file-based approach? A) No recovery, inefficient, no simultaneous access, separation and isolation, duplication, data dependence, fixed queries. B) Allows for efficient retrieval, insertion, update, and management of data. C) Provides information necessary for managing organisations effectively. D) Handles the daily transactions of an organisation. Show Answer Correct Answer: A) No recovery, inefficient, no simultaneous access, separation and isolation, duplication, data dependence, fixed queries. 20. Which of the following is a characteristic of NoSQL databases? A) Supports only SQL queries. B) Relational data storage. C) Fixed schema requirements. D) Schema-less data storage. Show Answer Correct Answer: D) Schema-less data storage. 21. The third step in the data modeling process with a packaged data model is: A) Rename identified data elements. B) Rename relationships. C) Map data to be used from package to data in current databases. D) Interview users. Show Answer Correct Answer: C) Map data to be used from package to data in current databases. 22. Generalization is a top-down process. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 23. What is the purpose of CRUD operations? A) To play games. B) To manipulate data. C) To write stories. D) To create art. Show Answer Correct Answer: B) To manipulate data. 24. When considering database selection, which factor is NOT typically important? A) Volume of data. B) Data storage requirements. C) User interface design. D) Type of queries. Show Answer Correct Answer: C) User interface design. 25. Insertion of a large number of entries at a time into an index is referred to as ..... of the index. A) Loading. B) Bulk insertion. C) Bulk loading. D) Increase insertion. Show Answer Correct Answer: C) Bulk loading. ← PreviousNext →Related QuizzesClass 12 Computer Science Chapter 3 Database Management Systems Quiz 1Class 12 Computer Science Chapter 3 Database Management Systems Quiz 2Class 12 Computer Science Chapter 3 Database Management Systems Quiz 3Class 12 Computer Science Chapter 3 Database Management Systems Quiz 4Class 12 Computer Science Chapter 3 Database Management Systems Quiz 5Class 12 Computer Science Chapter 3 Database Management Systems Quiz 6Class 12 Computer Science Chapter 3 Database Management Systems Quiz 7Class 12 Computer Science Chapter 3 Database Management Systems Quiz 8Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books