This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 3 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 3 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Why should Students and Courses be in separate tables? A) To avoid repeating course names for every student. B) To reduce number of tables. C) To remove primary keys. D) To allow redundancy. Show Answer Correct Answer: A) To avoid repeating course names for every student. 2. Which type of architecture is best for large-scale web applications? A) 1-Tier. B) 2-Tier. C) 3-Tier. D) Single User. Show Answer Correct Answer: C) 3-Tier. 3. In packaged data models, strong entities always have ..... between them. A) Weak entities. B) 1:1 relationships. C) 1:M relationships. D) M:N relationships. Show Answer Correct Answer: D) M:N relationships. 4. What does normalization mean in the context of databases? A) Normalization is the process of combining multiple databases into one. B) Normalization is the method of backing up data to prevent loss. C) Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. D) Normalization refers to the encryption of sensitive data in a database. Show Answer Correct Answer: C) Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. 5. The USE command? A) Is used to load code from another file. B) Has been deprecated and should be avoided for security reasons. C) Is a pseudo name for the SELECT command. D) Should be used to choose the database you want to use once you've connected to MySQL. Show Answer Correct Answer: D) Should be used to choose the database you want to use once you've connected to MySQL. 6. What is normalization in databases? A) Normalization in databases is the process of organizing data to minimize redundancy and dependency. B) Normalization is the method of encrypting data for security purposes. C) Normalization involves creating multiple copies of the same data for backup. D) Normalization is the process of deleting all data from a database. Show Answer Correct Answer: A) Normalization in databases is the process of organizing data to minimize redundancy and dependency. 7. Identify the encryption type that uses the same key for both encryption and decryption. A) Asymmetric encryption. B) Symmetric encryption. C) Public-key encryption. D) Hashing. Show Answer Correct Answer: B) Symmetric encryption. 8. Graph databases are ideal for handling many-to-many relationships. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 9. In the relational database model, data is organized into: A) Objects. B) Records. C) Tables. D) Hierarchies. Show Answer Correct Answer: C) Tables. 10. How do document stores like MongoDB organize data? A) In JSON-like documents. B) In key-value pairs. C) In columns. D) In tables. Show Answer Correct Answer: A) In JSON-like documents. 11. What year is considered the beginning of DBMS history? A) 1960. B) 1955. C) 1980. D) 1975. Show Answer Correct Answer: A) 1960. 12. Which file organization method stores data in a random order? A) Sequential. B) Indexed. C) Heap. D) Hashed. Show Answer Correct Answer: C) Heap. 13. How do you write a basic SELECT statement in SQL? A) SELECT column1, column2 FROM table name;. B) SELECT * FROM table name;. C) SELECT column1, column2 WHERE table name;. D) FROM table name SELECT column1, column2;. Show Answer Correct Answer: A) SELECT column1, column2 FROM table name;. 14. Which of the following is NOT Advantages of DBMS A) Increased data consistency. B) Reduced data redundancy. C) Improved data security. D) Increase data isolation. Show Answer Correct Answer: D) Increase data isolation. 15. Name one type of DBMS. A) NoSQL Database System. B) Relational Database Management System (RDBMS). C) Object-Oriented Database Management System. D) Hierarchical Database Management System. Show Answer Correct Answer: B) Relational Database Management System (RDBMS). 16. Differentiate between INNER JOIN and OUTER JOIN. A) INNER JOIN can return unmatched rows; OUTER JOIN cannot. B) INNER JOIN is used for aggregating data; OUTER JOIN is used for filtering data. C) INNER JOIN returns all rows from both tables; OUTER JOIN returns only matched rows. D) INNER JOIN returns matched rows; OUTER JOIN returns all rows from one table and matched rows from the other. Show Answer Correct Answer: D) INNER JOIN returns matched rows; OUTER JOIN returns all rows from one table and matched rows from the other. 17. What is the function of the HAVING clause in SQL? A) To create a new index on a table. B) To sort the result set in descending order. C) To filter records after aggregation has been performed. D) To join multiple tables together. Show Answer Correct Answer: C) To filter records after aggregation has been performed. 18. What is the primary purpose of metadata? A) To store user data. B) To perform data analysis. C) To describe data properties. D) To manage database security. Show Answer Correct Answer: C) To describe data properties. 19. Explain the concept of data integrity in database systems. A) Data integrity ensures the accuracy and consistency of data in a database. B) Data integrity is about the physical storage of data on disk drives. C) Data integrity ensures the availability of data during system failures. D) Data integrity refers to the speed of data retrieval in databases. Show Answer Correct Answer: A) Data integrity ensures the accuracy and consistency of data in a database. 20. What is a characteristic of a single-user database? A) It allows multiple users to access the database simultaneously. B) It supports only one user at a time. C) It is always stored on a server. D) It requires internet access to function. Show Answer Correct Answer: B) It supports only one user at a time. 21. Two-Phase Locking (2PL):A protocol that ensures serializable schedules using ..... A) Locks. B) Timestamps. C) Caches. D) Buffers. Show Answer Correct Answer: A) Locks. 22. What does the rename operation do in relational algebra? A) Combines relations. B) Creates a new relation. C) Deletes a relation. D) Changes the name of a relation. Show Answer Correct Answer: D) Changes the name of a relation. 23. What characterises Big Data management in modern databases? A) Limited storage capacity. B) Handling vast data volumes efficiently. C) Slow processing speeds. D) Restricted data types. Show Answer Correct Answer: B) Handling vast data volumes efficiently. 24. What is the purpose of the SELECT statement in SQL? A) To update existing records in a table. B) To create a new database. C) To delete records from a table. D) To retrieve data from one or more tables. Show Answer Correct Answer: D) To retrieve data from one or more tables. 25. A distributed database system is experiencing slow query performance. What is the most likely reason? A) Using a Relational Database Management System (RDBMS) instead of a NoSQL database. B) High network latency and inefficient query execution. C) Too many foreign key constraints. D) Lack of data replication. Show Answer Correct Answer: B) High network latency and inefficient query execution. ← 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 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 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books