This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 26 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 26 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How can a hospital's database management system improve patient care efficiency? A) Allowing patients to edit their own medical records. B) Eliminating the need for healthcare professionals. C) Providing real-time access to patient data for healthcare professionals. D) Storing data in unencrypted formats. Show Answer Correct Answer: C) Providing real-time access to patient data for healthcare professionals. 2. Which of the following is a type of Relational Database Management System (RDBMS)? A) Neo4j. B) Redis. C) Oracle Database. D) MongoDB. Show Answer Correct Answer: C) Oracle Database. 3. What is the purpose of DDL in SQL? A) To manipulate data. B) To define data structures. C) To enhance performance. D) To create backups. Show Answer Correct Answer: B) To define data structures. 4. Which of the following command is a type of Data Definition language command? A) Create. B) Update. C) Delete. D) Merge. Show Answer Correct Answer: A) Create. 5. What is the role of transaction management in a database system? A) Manage user authentication. B) Ensure data consistency and integrity. C) Design database tables. D) Optimize query performance. Show Answer Correct Answer: B) Ensure data consistency and integrity. 6. The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 7. Which of the following is a disadvantage of using a DBMS? A) Improved data security. B) Centralized data access. C) Increased data integrity. D) High overhead costs. Show Answer Correct Answer: D) High overhead costs. 8. Isolation:The effects of a transaction are not visible to other transactions until it ..... A) Commits. B) Starts. C) Rolls back. D) Aborts. Show Answer Correct Answer: A) Commits. 9. An association of various entities in an Entity-Relation model is known as A) Relationship. B) Record. C) Tuple. D) Field. Show Answer Correct Answer: A) Relationship. 10. In-memory databases are used for long-term data storage. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 11. The ..... rule states that an entity instance can simultaneously be a member of two (or more) subtypes. A) Disjoint. B) Overlap. C) Partial specialization. D) Total specialization. Show Answer Correct Answer: B) Overlap. 12. In a database transaction, what does the acronym ACID stand for? A) Atomicity, Consistency, Isolation, Durability. B) Accuracy, Consistency, Integrity, Durability. C) Atomicity, Concurrency, Isolation, Dependability. D) Accuracy, Concurrency, Integrity, Dependability. Show Answer Correct Answer: A) Atomicity, Consistency, Isolation, Durability. 13. What is SQL and how is it used in DBMS? A) SQL is a programming language used to manage and manipulate relational databases in a DBMS. B) SQL is a type of hardware used for data storage. C) SQL is a markup language for web development. D) SQL is a database management system itself. Show Answer Correct Answer: A) SQL is a programming language used to manage and manipulate relational databases in a DBMS. 14. In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 15. What is a database model? A) A database model is a type of software used for data analysis. B) A database model is a framework for organizing and defining the structure of data in a database. C) A database model is a method for securing data against unauthorized access. D) A database model is a programming language for creating applications. Show Answer Correct Answer: B) A database model is a framework for organizing and defining the structure of data in a database. 16. What is a subquery? A) A subquery is a command to delete records from a table. B) A subquery is a type of database index. C) A subquery is a function that aggregates data from multiple tables. D) A subquery is a nested query within another SQL query. Show Answer Correct Answer: D) A subquery is a nested query within another SQL query. 17. Which of the following is a completeness constraint? A) Total specialization. B) Partial generalization. C) Total recall. D) Partial hybridization. Show Answer Correct Answer: A) Total specialization. 18. What is a common use case for a Relational Database? A) Managing customer information in a business. B) Storing large video files for streaming. C) Tracking employee attendance records. D) Managing social media posts and interactions. Show Answer Correct Answer: A) Managing customer information in a business. 19. In terms of databases, what is meant by concurrency? A) Many users can interact with the database simultaneously. B) More than one user cannot edit data at the same time. C) Only a single user can interact with the database at a time. D) None of the above. Show Answer Correct Answer: A) Many users can interact with the database simultaneously. 20. ..... :A database spread across multiple locations. A) Distributed Database. B) Centralized Database. C) Relational Database. D) Hierarchical Database. Show Answer Correct Answer: A) Distributed Database. 21. ..... :Software that manages communication between client and server. A) Middleware. B) Compiler. C) Debugger. D) Spreadsheet. Show Answer Correct Answer: A) Middleware. 22. What is a characteristic of a hierarchical database? A) One-to-many relationships. B) Flat structure. C) Many-to-many relationships. D) No relationships. Show Answer Correct Answer: A) One-to-many relationships. 23. What uses a collection of tables to represent both data and relationships among the data? A) Relational model. B) Entity-Relationship data model. C) Object-based data models. D) None of the above. Show Answer Correct Answer: A) Relational model. 24. What is a transaction in the context of a database? A) A transaction is a sequence of operations treated as a single unit of work in a database. B) A transaction is a method for deleting records. C) A transaction is a backup of the database. D) A transaction is a type of database query. Show Answer Correct Answer: A) A transaction is a sequence of operations treated as a single unit of work in a database. 25. What is the purpose of SQL? A) To write reports. B) To design websites. C) To manage databases. D) To create diagrams. Show Answer Correct Answer: C) To manage databases. ← 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