This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 40 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 40 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is a disadvantage of the database approach? A) Improved data integrity. B) Increased concurrency. C) Data consistency. D) Complexity. Show Answer Correct Answer: D) Complexity. 2. Which database view is used by users who want to create tables and relationships between them? A) Physical view. B) Logical view. C) User view. D) None of the above. Show Answer Correct Answer: B) Logical view. 3. Which command is used to create a new table in SQL? A) CREATE. B) INSERT. C) UPDATE. D) DELETE. Show Answer Correct Answer: A) CREATE. 4. Which of the following is an example of an external database? A) Employee attendance records. B) B2B and B2C e-commerce catalogues. C) Internal payroll system. D) Personal email inbox. Show Answer Correct Answer: B) B2B and B2C e-commerce catalogues. 5. What is a primary role of a Database Administrator (DBA)? A) Performing data entry. B) Designing the database. C) Managing the DBMS. D) Writing application programs. Show Answer Correct Answer: C) Managing the DBMS. 6. What is the Alternate key? A) All the keys which are not primary key are called an alternate key. B) It is a candidate key which is currently not the primary key. C) A table may have single or multiple choices for the primary key. D) All of the above. Show Answer Correct Answer: D) All of the above. 7. Which of the following is a type of action query in MS Access? A) Select Query. B) Crosstab Query. C) Append Query. D) Report Query. Show Answer Correct Answer: C) Append Query. 8. What is a weak entity in an ER model? A) An entity with a primary key. B) An entity that cannot be uniquely identified. C) An entity that has no relationships. D) An entity with multiple attributes. Show Answer Correct Answer: B) An entity that cannot be uniquely identified. 9. In a relational database, each column represents a: A) Key. B) Tuple. C) Attribute. D) Record. Show Answer Correct Answer: C) Attribute. 10. What is the LAST step to request records or reports in a database management system? A) Run a query. B) Log in. C) Download the report. D) Log out. Show Answer Correct Answer: D) Log out. 11. What is the purpose of the SQL 'JOIN' clause? A) To delete rows from a table. B) To create a new table in the database. C) To update existing rows in a table. D) To combine rows from two or more tables based on a related column. Show Answer Correct Answer: D) To combine rows from two or more tables based on a related column. 12. Which of the following are ACID properties? A) Atomicity, Consistency, Isolation, and Durability. B) Availability, Consistency, Isolation, and Durability. C) Atomicity, Concurrency, Isolation, and Durability. D) Atomicity, Consistency, Integration, and Durability. Show Answer Correct Answer: A) Atomicity, Consistency, Isolation, and Durability. 13. What does the INNER JOIN do? A) Returns unique records. B) Returns matching records. C) Returns all records. D) Returns no records. Show Answer Correct Answer: B) Returns matching records. 14. What does the ROLLBACK command do? A) Undoes transactions that have not been committed. B) Saves all changes made to the database. C) Deletes a database. D) Creates a new database. Show Answer Correct Answer: A) Undoes transactions that have not been committed. 15. What does the term "atomic" mean in the context of database attributes? A) Attributes are indivisible. B) Attributes can be divided. C) Attributes are composite. D) Attributes can have multiple values. Show Answer Correct Answer: A) Attributes are indivisible. 16. What is structured query language (SQL)? A) A standard query language used within relational databases. B) A programming language used to query databases. C) A hardware device used to store data. D) A network protocol. Show Answer Correct Answer: A) A standard query language used within relational databases. 17. MySQL is A) A Programming language. B) A Markup language. C) A technique for writing reliable programs. D) A Relational Database Management System. Show Answer Correct Answer: D) A Relational Database Management System. 18. How does normalization improve database design? A) Normalization reduces redundancy and improves data integrity in database design. B) Normalization increases data duplication and decreases efficiency in database design. C) Normalization complicates the database structure and hinders performance. D) Normalization eliminates the need for indexing and slows down queries in database design. Show Answer Correct Answer: A) Normalization reduces redundancy and improves data integrity in database design. 19. How does a DBMS enable more information to be derived from the same amount of data? A) By increasing data redundancy for backup purposes. B) By limiting access to data for security reasons. C) By integrating operational data for cross-departmental use. D) By restricting data sharing among users. Show Answer Correct Answer: C) By integrating operational data for cross-departmental use. 20. What is 'data normalisation' in the context of databases? A) The process of increasing data redundancy. B) The process of organising data to reduce redundancy. C) The process of encrypting data. D) The process of backing up data. Show Answer Correct Answer: B) The process of organising data to reduce redundancy. 21. Which of the following is a common type of NoSQL database? A) Document Store. B) Relational Database. C) Hierarchical Database. D) Object-Oriented Database. Show Answer Correct Answer: A) Document Store. 22. What describes the structure of the whole database for a community of users? A) Internal or Physical level. B) Conceptual or Logical level. C) External or View level. D) None of the above. Show Answer Correct Answer: B) Conceptual or Logical level. 23. ..... :Law protecting healthcare information. A) HIPAA. B) FERPA. C) OSHA. D) ADA. Show Answer Correct Answer: A) HIPAA. 24. Which of the following is NOT a characteristic of a database? A) Data Redundancy Control. B) Data Integrity. C) Data Fragmentation. D) Data Security. Show Answer Correct Answer: C) Data Fragmentation. 25. What is a key benefit of data integrity management? A) Increased data redundancy. B) Minimized data inconsistency. C) Higher costs. D) More complex data access. Show Answer Correct Answer: B) Minimized data inconsistency. ← 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