This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 4 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 4 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of the ORDER BY clause? A) To group data. B) To join tables. C) To sort data. D) To filter data. Show Answer Correct Answer: C) To sort data. 2. What is the purpose of database normalization? A) To increase data redundancy for faster access. B) To enhance the visual representation of data in reports. C) The purpose of database normalization is to minimize data redundancy and ensure data integrity. D) To simplify database queries by merging tables. Show Answer Correct Answer: C) The purpose of database normalization is to minimize data redundancy and ensure data integrity. 3. Commit:The successful completion of a transaction where all changes are ..... A) Permanently saved. B) Temporarily stored. C) Deleted. D) Rolled back. Show Answer Correct Answer: A) Permanently saved. 4. What is the primary purpose of a Database Management System? A) To perform data analysis. B) To design hardware systems. C) To manage and organize data. D) To create software applications. Show Answer Correct Answer: C) To manage and organize data. 5. Which company uses Firebase for live, real-time updates? A) Reddit. B) The New York Times. C) Coca-Cola. D) American Airlines. Show Answer Correct Answer: B) The New York Times. 6. In a relational database, what is the purpose of a primary key? A) To link tables together. B) To ensure data integrity. C) To store unstructured data. D) To define relationships between records. Show Answer Correct Answer: B) To ensure data integrity. 7. Data software for working with the database A) DB. B) DBMS. C) BZ. D) None of the above. Show Answer Correct Answer: B) DBMS. 8. Which of the following is an example of a Relational DBMS? A) MongoDB. B) MySQL. C) Cassandra. D) Neo4j. Show Answer Correct Answer: B) MySQL. 9. What is the difference between a database and a database management system? A) A database stores data; a DBMS is a type of hardware. B) A database is the software; a DBMS is the data itself. C) A database is the data itself; a DBMS is the software that manages the database. D) A database is a collection of files; a DBMS is a programming language. Show Answer Correct Answer: C) A database is the data itself; a DBMS is the software that manages the database. 10. What is the role of a primary key in a relational database? A) A primary key is used to create indexes for faster data retrieval. B) A primary key is optional and can be left blank. C) A primary key uniquely identifies each record in a table and ensures that no duplicate entries exist. D) A primary key is used to encrypt data in the database. Show Answer Correct Answer: C) A primary key uniquely identifies each record in a table and ensures that no duplicate entries exist. 11. Which model organizes data in a tree-like structure with a single parent for each record? A) Relational Model. B) Network Model. C) Hierarchical Model. D) Object-Oriented Model. Show Answer Correct Answer: C) Hierarchical Model. 12. Which of the following refers to the number of tuples in a relation? A) Entity. B) Column. C) Cardinality. D) Key. Show Answer Correct Answer: C) Cardinality. 13. The subtype discriminator is a composite attribute when there is a(n): A) Overlap rule. B) Disjoint rule. C) Partial specialization. D) Full specialization. Show Answer Correct Answer: A) Overlap rule. 14. What is normalization in the context of a relational database? A) The process of optimizing queries. B) The process of designing a database to reduce redundancy. C) The process of adding new tables. D) The process of deleting old data. Show Answer Correct Answer: B) The process of designing a database to reduce redundancy. 15. How does a check constraint function in SQL? A) It ensures that all SQL commands are checked for errors before execution. B) It restricts the type of data that can be inserted into a table based on specific conditions. C) It checks and removes incorrect entries from a table automatically. D) It verifies user permissions before allowing data insertion. Show Answer Correct Answer: B) It restricts the type of data that can be inserted into a table based on specific conditions. 16. Which one of the following commands is used to modify a column inside a table? A) Update. B) Drop. C) Alter. D) Set. Show Answer Correct Answer: C) Alter. 17. What is a characteristic of naive users? A) Use SQL frequently. B) Design databases. C) Depend on GUI simplicity. D) Familiar with DBMS. Show Answer Correct Answer: C) Depend on GUI simplicity. 18. What is data independence? A) Changes in data structure without affecting other levels. B) A type of data. C) A programming language. D) A database model. Show Answer Correct Answer: A) Changes in data structure without affecting other levels. 19. In a multi-user database environment, what does "concurrency" primarily refer to? A) The number of users accessing the database. B) Simultaneous execution of multiple transactions. C) Database processing speed. D) Number of database servers. Show Answer Correct Answer: B) Simultaneous execution of multiple transactions. 20. Which of the following is a benefit of integrating a hospital's database management system with other health systems? A) Makes patient data less secure. B) Increases the workload of healthcare staff. C) Ensures real-time data exchange and reduces manual errors. D) Complicates the data retrieval process. Show Answer Correct Answer: C) Ensures real-time data exchange and reduces manual errors. 21. What does the 'D' in ACID stand for? A) Durability. B) Dependability. C) Data Integrity. D) Decoupling. Show Answer Correct Answer: A) Durability. 22. What is normalization and why is it important in database design? A) Normalization is important in database design because it minimizes data redundancy, ensures data integrity, and simplifies data management. B) Normalization is only for large databases. C) Normalization increases data redundancy. D) Normalization complicates data management. Show Answer Correct Answer: A) Normalization is important in database design because it minimizes data redundancy, ensures data integrity, and simplifies data management. 23. What is the role of a database engine? A) To create user interfaces. B) To manage hardware resources. C) To handle queries and data retrieval. D) To perform data entry tasks. Show Answer Correct Answer: C) To handle queries and data retrieval. 24. How does the size of a DBMS impact its efficiency? A) Smaller size results in higher costs. B) Larger size occupies more disk space and memory. C) Larger size leads to faster performance. D) Smaller size requires more memory to run efficiently. Show Answer Correct Answer: B) Larger size occupies more disk space and memory. 25. When a company needs a dynamic web application that interacts with a database and provides real-time updates. What combination of technologies should they use? A) JavaScript, AJAX, and a server-side language like PHP or Node.js. B) Static HTML files with no database. C) HTML, CSS, and JavaScript only. D) Only JavaScript and no backend. Show Answer Correct Answer: A) JavaScript, AJAX, and a server-side language like PHP or Node.js. ← 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 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 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books