This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 2 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 2 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... :Protecting personal and sensitive data. A) Privacy. B) Encryption. C) Authentication. D) Backup. Show Answer Correct Answer: A) Privacy. 2. What does ER stand for in ER Model? A) Entity Relationship. B) Entity Relation. C) Entity Real. D) Entity Report. Show Answer Correct Answer: A) Entity Relationship. 3. Describe the ACID properties in database transactions. A) ACID properties:Atomicity, Consistency, Isolation, Durability. B) Atomicity, Consistency, Isolation, Accessibility. C) Accuracy, Clarity, Integrity, Reliability. D) Atomicity, Concurrency, Isolation, Timeliness. Show Answer Correct Answer: A) ACID properties:Atomicity, Consistency, Isolation, Durability. 4. What do relational databases tend to have in common? A) Primary keys. B) Records. C) Fields. D) Indexes. Show Answer Correct Answer: A) Primary keys. 5. The model that uses tables with rows and columns is called: A) Object-Oriented Model. B) Hierarchical Model. C) Relational Model. D) Network Model. Show Answer Correct Answer: C) Relational Model. 6. Which of the following is NOT a feature of a DBMS? A) User authentication. B) Data encryption. C) Network configuration. D) Hardware management. Show Answer Correct Answer: D) Hardware management. 7. In E-R diagram an entity set is represented by a A) Rectangle. B) Ellipse. C) Diamond box. D) Circle. Show Answer Correct Answer: A) Rectangle. 8. What is the main advantage of using a DBMS? A) Centralized data management. B) Higher costs. C) Manual data processing. D) Increased data redundancy. Show Answer Correct Answer: A) Centralized data management. 9. What transforms raw data into meaningful information? A) Computational processing. B) Contextualisation and analysis. C) Storage techniques. D) Database design. Show Answer Correct Answer: B) Contextualisation and analysis. 10. The following figure is an example of total specialization. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 11. Which of the following commands is part of Data Definition Language (DDL)? A) SELECT. B) UPDATE. C) CREATE. D) INSERT. Show Answer Correct Answer: C) CREATE. 12. What is the result of the following SQL statement? SELECT * FROM employees WHERE age > 30; A) All employees. B) Employees older than 30. C) Employees younger than 30. D) All employees exactly 30 years old. Show Answer Correct Answer: B) Employees older than 30. 13. A collection of related data. A) Information. B) Valuable information. C) Database. D) Metadata. Show Answer Correct Answer: C) Database. 14. Define primary key in a relational database. A) A primary key is an optional field in a database table. B) A primary key is a unique identifier for a record in a relational database table. C) A primary key is a foreign key in another table. D) A primary key can contain duplicate values. Show Answer Correct Answer: B) A primary key is a unique identifier for a record in a relational database table. 15. What is the purpose of the TRUNCATE statement in SQL? A) To update existing records in a table. B) To create a new table in the database. C) To delete a specific record from a table. D) To remove all records from a table without logging individual row deletions. Show Answer Correct Answer: D) To remove all records from a table without logging individual row deletions. 16. Which of the following is a common use of a database index? A) To increase data redundancy. B) To manage user permissions. C) To speed up data retrieval. D) To store large amounts of data. Show Answer Correct Answer: C) To speed up data retrieval. 17. A company restricts salary updates to managers only. Which feature ensures this? A) Indexing. B) Authorization. C) Normalization. D) Metadata. Show Answer Correct Answer: B) Authorization. 18. Which language is used for defining and manipulating data in a relational database? A) Java. B) Python. C) SQL. D) C++. Show Answer Correct Answer: C) SQL. 19. List three advantages of using a DBMS. A) High cost, complex data management, and data inconsistency. B) Data security, data integrity, and efficient data retrieval. C) Data duplication, slow data retrieval, and data insecurity. D) Limited storage capacity, data redundancy, and slow data processing. Show Answer Correct Answer: B) Data security, data integrity, and efficient data retrieval. 20. In a car rental system, a CUSTOMER can rent many CARS, and a CAR can be rented by many CUSTOMERS. Which relationship best shows this? A) A one-to-one relationship between CUSTOMER and RENTAL. B) A one-to-many relationship between CAR and RENTAL. C) A one-to-many relationship between CUSTOMER and RENTAL. D) A many-to-many relationship between CUSTOMER and CAR. Show Answer Correct Answer: D) A many-to-many relationship between CUSTOMER and CAR. 21. As the number of files increases in a file system, what happens to system administration? A) It becomes easier. B) It remains unchanged. C) It becomes more complex and difficult. D) It eliminates the need for report generation. Show Answer Correct Answer: C) It becomes more complex and difficult. 22. Which DBMS is used by Spotify to store and retrieve music metadata quickly? A) PostgreSQL. B) HBase. C) Microsoft SQL Server. D) SAP HANA. Show Answer Correct Answer: B) HBase. 23. What is the full form of DBMS? A) Data of Binary Management System. B) Database Management System. C) Database Management Service. D) Data Backup Management System. Show Answer Correct Answer: B) Database Management System. 24. ..... is a set of one or more attributes taken collectively to uniquely identify a row/record in a table. A) Primary Key. B) Foreign key. C) Super key. D) Candidate key. Show Answer Correct Answer: A) Primary Key. 25. If you were collecting and storing information about your music collection, an album would be considered a(n) ..... A) Relation. B) Entity. C) Instance. D) Attribute. Show Answer Correct Answer: B) Entity. ← PreviousNext →Related QuizzesClass 12 Computer Science Chapter 3 Database Management Systems Quiz 1Class 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 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books