This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 53 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 53 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. If user A is using a single-user database, what must users B and C do? A) They can access the database at the same time. B) They must wait until user A is done. C) They can edit the database remotely. D) They can view but not edit the database. Show Answer Correct Answer: B) They must wait until user A is done. 2. What happens to the foreign key in a binary relationship with total participation constraint? A) It can be null. B) It acquires NOT NULL constraint. C) It becomes a primary key. D) It is removed. Show Answer Correct Answer: B) It acquires NOT NULL constraint. 3. What does the SQL LIKE operator do? A) Compares numeric values. B) Matches a specified pattern in a column. C) Sorts results. D) Groups results. Show Answer Correct Answer: B) Matches a specified pattern in a column. 4. What does normalization mean in database design? A) Normalization is the process of combining multiple databases into one. B) Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. C) Normalization refers to the method of encrypting data for security purposes. D) Normalization is the technique of backing up data to prevent loss. Show Answer Correct Answer: B) Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. 5. How does method overloading differ from method overriding? A) Overloading is defining methods with the same name in different classes, while overriding is defining methods with the same name in the same class. B) Overloading changes the method signature, while overriding keeps the method signature the same. C) Overloading requires final methods, while overriding does not. D) Overloading requires inheritance, whereas overriding does not. Show Answer Correct Answer: B) Overloading changes the method signature, while overriding keeps the method signature the same. 6. Which of the following is an example of a hierarchical model? A) Oracle DB. B) Excel Spreadsheet. C) Organizational Chart. D) Online Shopping Cart. Show Answer Correct Answer: C) Organizational Chart. 7. What is horizontal partitioning? A) Placing some rows of a relation at one site. B) Creating multiple copies of the entire database. C) Storing all data in a single location. D) Distributing columns of a relation among different sites. Show Answer Correct Answer: A) Placing some rows of a relation at one site. 8. You are a database administrator for a large company with multiple departments. Each department needs a separate view of the employee data, showing only relevant information (e.g., HR sees salary, a project manager sees project assignments). Which of the following components of the three-schema architecture would you use to implement these specific views? A) Conceptual Schemas. B) Internal Schemas. C) External Schemas. D) Database Instances. Show Answer Correct Answer: C) External Schemas. 9. A database management system (DBMS) is a: A) Software system used to create, maintain, and provide controlled access to a database. B) Hardware system used to create, maintain, and provide controlled access to a database. C) Hardware system used to create, maintain, and provide uncontrolled access to a database. D) Software system used to create, maintain, and provide uncontrolled access to a database. Show Answer Correct Answer: A) Software system used to create, maintain, and provide controlled access to a database. 10. One or more very large databases containing both detailed and summarized data for a number of years that is used for analysis rather than transaction processing. A) Data warehouse. B) Data Sharing. C) Database. D) Data Mining. Show Answer Correct Answer: A) Data warehouse. 11. What is the history of the first commercially available relational database management system (RDBMS)? A) Oracle. B) MySQL. C) IBM DB2. D) Microsoft SQL Server. Show Answer Correct Answer: A) Oracle. 12. Which of the following is not a DML command? A) Insert. B) Delete. C) Update. D) Truncate. Show Answer Correct Answer: D) Truncate. 13. What are the 4 properties of a transaction? A) Atomicity, Consistency, Isolation, Durability. B) Concurrency, Isolation, Durability, Consistency. C) Atomicity, Concurrency, Isolation, Durability. D) Atomicity, Consistency, Isolation, Concurrency. Show Answer Correct Answer: A) Atomicity, Consistency, Isolation, Durability. 14. What is the role of a database designer? A) To write software programs. B) To create video games. C) To identify data to be stored. D) To manage user access. Show Answer Correct Answer: C) To identify data to be stored. 15. When identifying the parts of the packaged data model that apply to your organization, one should first start with: A) Entities. B) Attributes. C) Primary keys. D) Relationships. Show Answer Correct Answer: A) Entities. 16. Which SQL keyword is used to sort the result set? A) ORDER BY. B) SORT BY. C) ARRANGE BY. D) GROUP BY. Show Answer Correct Answer: A) ORDER BY. 17. In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy? A) Triggers. B) Pointers. C) Locks. D) Cursors. Show Answer Correct Answer: C) Locks. 18. Which of the following is a valid SQL constraint? A) VALUE KEY. B) UNIQUE. C) INDEX. D) LIST. Show Answer Correct Answer: B) UNIQUE. 19. Which of the following is not a type of MS Access database object? A) Table. B) Form. C) Worksheets. D) Modules. Show Answer Correct Answer: C) Worksheets. 20. An entity cluster is: A) A formal method for specifying attributes of related entities. B) A set of one or more entity types and associated relationships grouped into a single abstract entity type. C) A useful way to present data for a small and fairly simple organization. D) A way of developing more granular views of the data model. Show Answer Correct Answer: B) A set of one or more entity types and associated relationships grouped into a single abstract entity type. 21. A manager has requested a list of all products over $ 100 and in size "Large" . How would this information be retrieved? A) Sort Ascending. B) Sort Descending. C) Filter. D) Find. Show Answer Correct Answer: C) Filter. 22. What does the term 'data integrity' refer to in a database? A) Ensuring data is accurate and consistent. B) Storing data in multiple formats. C) Increasing data redundancy. D) Limiting data access to authorized users. Show Answer Correct Answer: A) Ensuring data is accurate and consistent. 23. Which one will delete the table data as well as table structure? A) DELETE. B) DROP. C) All the above. D) None of the above. Show Answer Correct Answer: B) DROP. 24. What is an advantage of using joins in a DBMS? A) They reduce data redundancy. B) They simplify file storage. C) They eliminate the need for backups. D) They combine related tables on keys. Show Answer Correct Answer: D) They combine related tables on keys. 25. In terms of databases, what does consistency mean? A) All data inputted follows the same format. B) All users have the same view of data. C) The data is the same no matter who views it. D) None of the above. Show Answer Correct Answer: B) All users have the same view of data. ← 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