This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 9 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which view is used to arrange table data in different graphical layouts to summarize data? A) Table view. B) Design view. C) Data sheet view. D) Pivot chart view. Show Answer Correct Answer: D) Pivot chart view. 2. What are the techniques of managing concurrency control? A) Locking, Time-stamping, Multi-version Concurrency Control. B) Locking, Time-stamping, Data Validation. C) Locking, Data Verification, Multi-version Concurrency Control. D) Time-stamping, Data Validation, Data Verification. Show Answer Correct Answer: A) Locking, Time-stamping, Multi-version Concurrency Control. 3. What type of relationship involves two entities? A) Unary. B) Binary. C) N-array. D) Ternary. Show Answer Correct Answer: B) Binary. 4. What is a stored procedure in SQL? A) A stored procedure is a type of index that speeds up data retrieval. B) A stored procedure is a command used to delete records. C) A stored procedure is a method for aggregating data. D) A stored procedure is a set of SQL statements that can be stored and executed as a single unit. Show Answer Correct Answer: D) A stored procedure is a set of SQL statements that can be stored and executed as a single unit. 5. Which of the following describes a weak entity? A) An entity with a primary key. B) An entity that has a strong relationship. C) An entity that cannot be uniquely identified. D) An entity with multiple attributes. Show Answer Correct Answer: C) An entity that cannot be uniquely identified. 6. How can indexing improve SQL query performance? A) Indexing improves SQL query performance by allowing faster data retrieval through optimized data structures. B) Indexing complicates data structures, making queries more complex. C) Indexing has no effect on SQL query performance or efficiency. D) Indexing slows down data retrieval by creating additional overhead. Show Answer Correct Answer: A) Indexing improves SQL query performance by allowing faster data retrieval through optimized data structures. 7. The process of ensuring that the database reflects all real-world changes is called: A) Data redundancy. B) Data persistence. C) Data recovery. D) Data abstraction. Show Answer Correct Answer: B) Data persistence. 8. Explain the difference between relations and attributes. A) Attributes are tables; relations are columns in those tables. B) Relations are the same as attributes. C) Relations refer to the data type of a column. D) Relations are tables; attributes are columns in those tables. Show Answer Correct Answer: D) Relations are tables; attributes are columns in those tables. 9. A NULL value is treated as a blank or 0. A) True. B) False. C) None of the above. D) None of the above. Show Answer Correct Answer: B) False. 10. An ..... consists of a search-key value and pointers to one or more records with that value as their search-key value. A) Index entry. B) Index hash. C) Index cluster. D) Index map. Show Answer Correct Answer: A) Index entry. 11. Suppose a banking system has a Transactions table. To ensure that withdrawals do not exceed available balance, which database constraint should be applied? A) FOREIGN KEY. B) NOT NULL. C) CHECK. D) UNIQUE. Show Answer Correct Answer: C) CHECK. 12. What is a potential issue with the greater impact of a failure in a DBMS? A) Minimal disruption to operations. B) Decreased reliance on the DBMS. C) Reduced vulnerability of the system. D) Halt in operations due to component failure. Show Answer Correct Answer: D) Halt in operations due to component failure. 13. What type of data independence is the ability to modify logical or conceptual schema without changing the external schemas or application programs? A) Physical Data Independence. B) Logical Data Independence. C) All the above. D) None of the above. Show Answer Correct Answer: B) Logical Data Independence. 14. What is an advantage of file-based systems? A) Simplicity B) High security C) Easy to scale D) Automatic backups A) Limited access. B) Difficult to manage. C) Complexity. D) A) Simplicity. Show Answer Correct Answer: D) A) Simplicity. 15. In a relational database, what is a primary key? A) An attribute that uniquely identifies a tuple. B) An attribute that can be duplicated. C) An attribute that is optional. D) An attribute that links two tables. Show Answer Correct Answer: A) An attribute that uniquely identifies a tuple. 16. Which department is most likely to be consulted to resolve a data discrepancy? A) Security Team. B) Maintenance. C) Health Information Management. D) Marketing. Show Answer Correct Answer: C) Health Information Management. 17. What does a schema diagram visually represent? A) Database operations. B) Table structures and their relationships. C) SQL queries. D) Database security measures. Show Answer Correct Answer: B) Table structures and their relationships. 18. What is the role of procedures in a database system? A) To store data. B) To enforce standards. C) To manage hardware. D) To design the database. Show Answer Correct Answer: B) To enforce standards. 19. ..... :Automates deployment and system operations. A) DevOps. B) Frontend. C) Database. D) Networking. Show Answer Correct Answer: A) DevOps. 20. What is the significance of primary keys in the relational model? A) They uniquely identify a record in a table. B) They allow null values in a table. C) They are used for encryption. D) They define the physical storage structure of the database. Show Answer Correct Answer: A) They uniquely identify a record in a table. 21. The ..... refers to the way data is organized in and accessible from DBMS. A) Database hierarchy. B) Database organization. C) Data model. D) Data sharing. Show Answer Correct Answer: C) Data model. 22. What does ACID stand for in database management? A) Addition, Consistency, Isolation, Durability. B) Atomicity, Consistency, Integration, Durability. C) Atomicity, Consistency, Isolation, Durability. D) Atomicity, Concurrency, Isolation, Durability. Show Answer Correct Answer: C) Atomicity, Consistency, Isolation, Durability. 23. What is a file-based data management system? A) A type of software that allows users to access and organize small groups of data. B) A software application through which a user interacts with a database. C) A collection of data related in a logical manner. D) A system which allows users to have complete control over the DB. Show Answer Correct Answer: A) A type of software that allows users to access and organize small groups of data. 24. What is the main function of a database management system in a hospital? A) Automate all medical procedures. B) Provide a centralized system to store and retrieve patient data. C) Allow unrestricted access to patient records. D) Replace healthcare professionals. Show Answer Correct Answer: B) Provide a centralized system to store and retrieve patient data. 25. Which normal form removes partial dependency? A) 1NF. B) 2NF. C) 3NF. D) BCNF. Show Answer Correct Answer: B) 2NF. ← 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 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books