This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 13 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 13 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. An entity instance of a subtype represents the same entity instance of the supertype. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 2. Which of the following is a feature of Relational Databases? A) Use of tables to store data with relationships between them. B) Data is organized in a hierarchical structure with no tables. C) Data stored in a single flat file without relationships. D) Use of complex data types like JSON and XML exclusively. Show Answer Correct Answer: A) Use of tables to store data with relationships between them. 3. In an ER diagram, a relationship set is represented by: A) A rectangle. B) A diamond. C) An ellipse. D) A line. Show Answer Correct Answer: B) A diamond. 4. One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 5. What is a factor contributing to the cost of DBMSs? A) Fixed cost regardless of usage. B) Variability based on functionality and environment. C) Low initial purchase price. D) Free annual maintenance services. Show Answer Correct Answer: B) Variability based on functionality and environment. 6. ..... :Dividing data across multiple sites. A) Data Partitioning. B) Data Encryption. C) Data Replication. D) Data Compression. Show Answer Correct Answer: A) Data Partitioning. 7. Which architecture is designed to promote data independence in a DBMS? A) Two-tier architecture. B) Three-tier architecture. C) Single-tier architecture. D) Multi-tier architecture. Show Answer Correct Answer: B) Three-tier architecture. 8. Which of the following best describes the term 'Normalization' in databases? A) A process of reducing redundancy in a database. B) A technique for speeding up query execution. C) A method of encrypting database records. D) A way to back up database files. Show Answer Correct Answer: A) A process of reducing redundancy in a database. 9. In a distributed database architecture, what is the main benefit of replicating databases to various sites and interconnecting them via a network? A) Improved database performance and security. B) Reduced number of users. C) Increased vulnerability to failure. D) Limited data sharing. Show Answer Correct Answer: A) Improved database performance and security. 10. What is the function of the LIMIT clause in SQL? A) To group records. B) To restrict the number of records returned. C) To sort the results. D) To filter records. Show Answer Correct Answer: B) To restrict the number of records returned. 11. What does a binary relationship with cardinality ratio 1:1 indicate? A) Many to many. B) One to many. C) Many to one. D) One to one. Show Answer Correct Answer: D) One to one. 12. Which of the following is an example of a many-to-many relationship? A) Students and classes. B) Employees and departments. C) Customers and orders. D) Authors and books. Show Answer Correct Answer: A) Students and classes. 13. Which of the following is a NoSQL database? A) PostgreSQL. B) SQLite. C) MongoDB. D) MySQL. Show Answer Correct Answer: C) MongoDB. 14. How do Codd's rules ensure data integrity in a database? A) Codd's rules allow unstructured data storage. B) Codd's rules focus solely on user interface design. C) Codd's rules eliminate the need for primary keys. D) Codd's rules ensure data integrity by enforcing structured data representation, primary keys, and foreign key relationships. Show Answer Correct Answer: D) Codd's rules ensure data integrity by enforcing structured data representation, primary keys, and foreign key relationships. 15. Which type of database supports data located at a single site? A) Centralized. B) Distributed. C) Relational. D) Hierarchical. Show Answer Correct Answer: A) Centralized. 16. What are the common types of failures in database systems? A) Database upgrades. B) Common types of failures in database systems include hardware failures, software bugs, human errors, network issues, and data corruption. C) Increased storage capacity. D) Power outages. Show Answer Correct Answer: B) Common types of failures in database systems include hardware failures, software bugs, human errors, network issues, and data corruption. 17. Using a packaged data model, projects take less time and cost because: A) Less personnel are required. B) Essential components and structures are already defined. C) There is more time taken to model the enterprise. D) Packaged data models only run in Oracle. Show Answer Correct Answer: B) Essential components and structures are already defined. 18. Which SQL clause groups rows sharing a property so that an aggregate function can be applied to each group? A) GROUP BY. B) ORDER BY. C) HAVING. D) FILTER BY. Show Answer Correct Answer: A) GROUP BY. 19. In a database, Multiple ..... can be created. A) Tables. B) Documents. C) Primary Key. D) All of these. Show Answer Correct Answer: A) Tables. 20. The database acts as the ..... of an information system. A) Output device. B) Central repository. C) User interface. D) Network controller. Show Answer Correct Answer: B) Central repository. 21. What is a collection of similar entities called? A) Entity Class. B) Entity Collection. C) Entity Group. D) Entity Set. Show Answer Correct Answer: D) Entity Set. 22. What does a schema with constraints enforce? A) User access levels. B) Data redundancy. C) Common formats. D) File storage. Show Answer Correct Answer: C) Common formats. 23. Which of the following is NOT an application of DBMS? A) Railway Reservation System. B) Library Management System. C) Banking System. D) Web Browsing. Show Answer Correct Answer: D) Web Browsing. 24. Which type of partitioning distributes the rows of a table into separate tables based on a key range? A) Vertical Partitioning. B) Horizontal Partitioning. C) Hash Partitioning. D) Composite Partitioning. Show Answer Correct Answer: A) Vertical Partitioning. 25. Which combination of key zooms the content of active cell in Access table? A) Ctrl + F2. B) Ctrl + F5. C) Shift + F2. D) Shift + F5. Show Answer Correct Answer: C) Shift + F2. ← 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