This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 33 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 33 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Incorrect Analysis Problem:Reading data while another transaction is ..... A) Updating it. B) Deleting it. C) Committing it. D) Rolling back. Show Answer Correct Answer: A) Updating it. 2. Which of the following is an example of a DML command? A) DROP. B) SELECT. C) ALTER. D) CREATE. Show Answer Correct Answer: B) SELECT. 3. A field of one table which is also a the primary key of another table A) Primary Key. B) Relational database. C) Data normalisation. D) Foreign Key. Show Answer Correct Answer: D) Foreign Key. 4. What is the purpose of the GROUP BY clause in SQL? A) To create new tables from existing data. B) To filter rows based on specific conditions. C) To group rows that have the same values in specified columns and perform aggregate calculations on them. D) To sort rows in ascending or descending order. Show Answer Correct Answer: C) To group rows that have the same values in specified columns and perform aggregate calculations on them. 5. ..... :Oversees information systems and data strategy. A) Chief Information Officer (CIO). B) Chief Financial Officer (CFO). C) Chief Marketing Officer (CMO). D) Chief Operating Officer (COO). Show Answer Correct Answer: A) Chief Information Officer (CIO). 6. What is the purpose of decomposition in database design? A) To simplify data. B) To combine schemas. C) To avoid repetition. D) To create new schemas. Show Answer Correct Answer: C) To avoid repetition. 7. In which type of distributed operation can a single SQL statement access data from multiple remote sites? A) Remote request. B) Remote transaction. C) Distributed transaction. D) Distributed request. Show Answer Correct Answer: D) Distributed request. 8. What is a developer interface in a DBMS? A) A feature that provides developers with commands for database management. 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 feature that provides developers with commands for database management. 9. In a ..... index, an index entry appears for only some of the search-key values. A) Dense. B) Sparse. C) Straight. D) Continuous. Show Answer Correct Answer: B) Sparse. 10. A game database designer needs to model the relationship between PLAYERS and ITEMS. Each Player can have many Items, and each Item can belong to many Players. Which type of relationship best represents this? A) Many-to-Many. B) One-to-Many. C) One-to-One. D) Create a one-to-one relationship between Players and Items. Show Answer Correct Answer: A) Many-to-Many. 11. Client/Server Architecture:Processing split between ..... and ..... A) Client, server. B) User, database. C) Host, network. D) Application, protocol. Show Answer Correct Answer: A) Client, server. 12. ..... :Unauthorized access, misuse, data loss, and system failure. A) Threats to Databases. B) Database Backups. C) Database Queries. D) Database Indexes. Show Answer Correct Answer: A) Threats to Databases. 13. How does data modeling in the hospital's database management system reduce errors? A) It allows each department to create its own patient records separately. B) It automatically eliminates the need for staff to enter patient data. C) It stores patient information without organizing it in a structured format. D) It ensures that all departments enter and access accurate and consistent information. Show Answer Correct Answer: D) It ensures that all departments enter and access accurate and consistent information. 14. In B+ tree the node which points to another node is called A) Leaf node. B) External node. C) Final node. D) Internal node. Show Answer Correct Answer: D) Internal node. 15. What is referential integrity in a database? A) Ensuring data is unique. B) Ensuring data is not null. C) Ensuring foreign keys match primary keys. D) Ensuring data is backed up. Show Answer Correct Answer: C) Ensuring foreign keys match primary keys. 16. Which HTML tag is used to create a hyperlink? A) . B) . C) . D) . Show Answer Correct Answer: A) . 17. In processes or threads concepts, there is a blocking of processes or treads that either compete for system resources or communicate with each other when each process or thread is waiting for a resource to be freed which is controlled by another process. These processes or treads could be examined with ..... A) Process Control Block. B) Deadlock. C) Deadblock. D) Multithreading. Show Answer Correct Answer: B) Deadlock. 18. In a database, what is the 'instance' at any given point in time? A) The set of schema definitions and constraints. B) The snapshot/collection of data stored in the database. C) The software that manages the database system. D) The physical hardware where the database resides. Show Answer Correct Answer: B) The snapshot/collection of data stored in the database. 19. Which key can include additional, unnecessary attributes? A) Candidate Key. B) Composite Key. C) Primary Key. D) Super Key. Show Answer Correct Answer: D) Super Key. 20. What is one advantage of using a database system? A) Higher costs. B) Improved data accessibility. C) Increased data redundancy. D) More complex management. Show Answer Correct Answer: B) Improved data accessibility. 21. Which of the following is NOT an application of databases? A) Watching movies. B) Purchasing groceries. C) Booking a holiday. D) Using the local library. Show Answer Correct Answer: A) Watching movies. 22. Rollforward:Redoing changes made by ..... transactions. A) Committed. B) Uncommitted. C) Aborted. D) Failed. Show Answer Correct Answer: A) Committed. 23. Sistem ..... yang menangani kondisi malfunction (crash) baik pada hardware ataupun software, juga mengandung security Protection yang menangani pengaksesan oleh user terlarang A) Proteksi. B) Maintain. C) Reset. D) Format. Show Answer Correct Answer: A) Proteksi. 24. What is a key consideration when implementing a database management system in a healthcare setting? A) Ensure that all data is stored in plain text for easy access. B) Allow patients to edit their own medical records. C) Provide open access to all hospital staff. D) Implement strong security measures to protect patient data. Show Answer Correct Answer: D) Implement strong security measures to protect patient data. 25. Which is a set of entities of the same type that share the same properties, or attributes. A) Relation set. B) Attribute set. C) Entity set. D) Entity model. Show Answer Correct Answer: C) Entity set. ← 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