This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 56 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 56 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which layer of a DBMS interacts directly with the database storage? A) Application layer. B) Physical layer. C) Logical layer. D) View layer. Show Answer Correct Answer: B) Physical layer. 2. What is the role of a data model? A) To define data structure. B) To optimize queries. C) To manage database security. D) To visualize data flow. Show Answer Correct Answer: A) To define data structure. 3. Disk (Media) Failure:Failure that destroys data stored on ..... ? A) Disk. B) Printer. C) Monitor. D) Keyboard. Show Answer Correct Answer: A) Disk. 4. What is the purpose of key constraints in a relation? A) To enforce referential integrity. B) To allow NULL values. C) To identify tuples uniquely. D) To define attribute domains. Show Answer Correct Answer: C) To identify tuples uniquely. 5. What is the maximum number of users normally supported by a workgroup database? A) 10. B) 30. C) 50. D) 100. Show Answer Correct Answer: C) 50. 6. Generalization in an ER model is: A) A process of defining a superclass from multiple subclasses. B) A process of defining a subclass from a superclass. C) Used to combine two entities into one. D) Represented by an ellipse in an ER diagram. Show Answer Correct Answer: A) A process of defining a superclass from multiple subclasses. 7. Which mapping does the DBMS check to determine the corresponding internal structures? A) External/Internal mapping. B) Conceptual/Internal mapping. C) Physical/Conceptual mapping. D) External/Conceptual mapping. Show Answer Correct Answer: B) Conceptual/Internal mapping. 8. Among OSI layers, which one provides user interfaces and support for services such as electronic mail, remote file access and transfer? A) Session layer. B) Application layer. C) Presentation layer. D) Transport layer. Show Answer Correct Answer: B) Application layer. 9. What are indexes and why are they important in databases? A) Indexes are used to store images in databases. B) Indexes are tools for data encryption in databases. C) Indexes are data structures that enhance the speed of data retrieval in databases. D) Indexes are methods for data backup in databases. Show Answer Correct Answer: C) Indexes are data structures that enhance the speed of data retrieval in databases. 10. Which of the following best describes relational databases? A) Data stored in hierarchical order. B) Data stored in flat text files. C) Data stored in tables with rows and columns linked by relationships. D) Data stored as images and videos. Show Answer Correct Answer: C) Data stored in tables with rows and columns linked by relationships. 11. What is the homework task for the database lesson? A) Design a new database system. B) Research and write about a database you didn't know before, including its name, purpose, users, and importance. C) Create a Google Form to collect data. D) Compare database systems with manual systems. Show Answer Correct Answer: B) Research and write about a database you didn't know before, including its name, purpose, users, and importance. 12. Explain the concept of normalization in database design. A) Normalization is the process of combining all data into a single table. B) Normalization eliminates the need for any relationships between tables. C) Normalization involves structuring a database to minimize redundancy and dependency by dividing data into related tables. D) Normalization is only concerned with increasing data storage capacity. Show Answer Correct Answer: C) Normalization involves structuring a database to minimize redundancy and dependency by dividing data into related tables. 13. What is the purpose of a schema in a database? A) To manage users. B) To create reports. C) To store data. D) To define structure. Show Answer Correct Answer: D) To define structure. 14. Packaged data models: A) Are ready to use right out of the box. B) Require customization. C) Allow partial specialization. D) Cannot be used for most applications. Show Answer Correct Answer: B) Require customization. 15. ..... :Collecting only necessary data. A) Data Minimization. B) Data Duplication. C) Data Expansion. D) Data Sharing. Show Answer Correct Answer: A) Data Minimization. 16. Which of the following is an example of a database in daily life? A) A calculator. B) A school's attendance system. C) A music playlist. D) A digital clock. Show Answer Correct Answer: B) A school's attendance system. 17. What is data modeling? A) The analysis and definition of data structures required in a database. B) The process of creating a database. C) The process of encrypting data. D) The process of compressing data. Show Answer Correct Answer: A) The analysis and definition of data structures required in a database. 18. What does the 'C' in ACID represent? A) Clarity. B) Consistency. C) Integrity. D) Durability. Show Answer Correct Answer: B) Consistency. 19. What does the DISTINCT keyword do in SQL? A) Sorts the results. B) Filters records. C) Groups records. D) Removes duplicate records. Show Answer Correct Answer: D) Removes duplicate records. 20. Which of the following is a common use case for NoSQL databases? A) Maintaining strict data integrity. B) Performing complex joins. C) Handling large volumes of unstructured data. D) Storing structured financial data. Show Answer Correct Answer: C) Handling large volumes of unstructured data. 21. Why File Based System become unpopular? A) It causes sync with all the data synchronization. B) It causes data redundancy. C) All the above. D) None of the above. Show Answer Correct Answer: B) It causes data redundancy. 22. Which of the following is a characteristic of a distributed database? A) It requires constant internet connection. B) It does not support modular growth. C) It provides local flexibility and customization. D) It can only be accessed from a central server. Show Answer Correct Answer: C) It provides local flexibility and customization. 23. In relational databases, what is the purpose of the UPDATE operation? A) Add new records to a table. B) Remove records from a table. C) Modify existing records in a table. D) Combine rows from different tables. Show Answer Correct Answer: C) Modify existing records in a table. 24. Name three types of database models. A) Graph model. B) Relational model, Document model, Key-value model. C) Object-oriented model. D) Hierarchical model. Show Answer Correct Answer: B) Relational model, Document model, Key-value model. 25. What is a view in SQL? A) A view is a virtual table based on the result set of a SQL query. B) A view is a type of index that speeds up data retrieval. C) A view is a physical table that stores data. D) A view is a command used to delete records. Show Answer Correct Answer: A) A view is a virtual table based on the result set of a SQL query. ← 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