This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 24 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 24 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The following figure shows an example of: A) The disjoint rule. B) The completeness rule. C) The underdog rule. D) The overlap rule. Show Answer Correct Answer: D) The overlap rule. 2. Which of the following is NOT a function of DBMS? A) Define Data. B) Destroy Hardware. C) Manipulate Data. D) Construct Database. Show Answer Correct Answer: B) Destroy Hardware. 3. Define a relational data structure. A) A relational data structure is a collection of unrelated data points. B) A relational data structure is a single table without any relationships. C) A relational data structure is a collection of data organized into tables (relations) that can be linked by relationships. D) A relational data structure is a type of data structure that only stores numeric values. Show Answer Correct Answer: C) A relational data structure is a collection of data organized into tables (relations) that can be linked by relationships. 4. A description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data. A) Subschema. B) Logical view. C) Physical view. D) Schema. E) External-level schema. Show Answer Correct Answer: D) Schema. 5. Which tool is used by a DBA to manage the database? A) Query Tools. B) Web Browser. C) Administration Tools. D) Text Editor. Show Answer Correct Answer: C) Administration Tools. 6. Write a SQL query to retrieve all records from a table named 'Students'. A) SELECT ALL FROM Students;. B) SELECT * FROM Students;. C) GET * FROM Students;. D) FETCH * FROM Students;. Show Answer Correct Answer: B) SELECT * FROM Students;. 7. Which of the following is a major advantage of using a DBMS over a file-based system? A) Better data consistency and integrity. B) Increased data redundancy. C) Slower performance. D) Less security control. Show Answer Correct Answer: A) Better data consistency and integrity. 8. What is the primary purpose of SQL? A) To manage and manipulate relational databases. B) To store and retrieve files on a server. C) To create and design websites. D) To perform complex mathematical calculations. Show Answer Correct Answer: A) To manage and manipulate relational databases. 9. Which of the following is not a Storage Manager Component? A) Transaction Manager. B) Logical Manager. C) Buffer Manager. D) File Manager. Show Answer Correct Answer: B) Logical Manager. 10. Billy is creating a database for several customers. How will he record whether or not they have a credit card? A) Yes/No. B) Text. C) Number. D) Currency. Show Answer Correct Answer: A) Yes/No. 11. ..... :Clearly explaining how data is collected and used. A) Transparency. B) Obscurity. C) Ambiguity. D) Secrecy. Show Answer Correct Answer: A) Transparency. 12. E-R model uses this symbol to represent weak entity set? A) Dotted rectangle. B) Diamond. C) Doubly outlined rectangle. D) None of these. Show Answer Correct Answer: C) Doubly outlined rectangle. 13. The process of organizing data to reduce redundancy is called: A) Indexing. B) Aggregation. C) Normalization. D) Querying. Show Answer Correct Answer: C) Normalization. 14. Which of the following is a disadvantage of file processing systems? A) Data redundancy. B) High data security. C) Multi-user access support. D) Efficient data handling. Show Answer Correct Answer: A) Data redundancy. 15. Which of the following is NOT a type of database architecture? A) Client-Server. B) Hierarchical. C) Flat-file. D) Parallel. Show Answer Correct Answer: D) Parallel. 16. There are six computers to be connected with each other through a connectivity device called hub. What will you do to create this connection? A) Create bus topology with straight line cable. B) Create ring topology by cyclic process. C) Create star topology by using connectivity device. D) Create mesh topology by connecting each other. Show Answer Correct Answer: C) Create star topology by using connectivity device. 17. Purpose of Log:To support undo and redo during ..... A) Recovery. B) Execution. C) Compilation. D) Encryption. Show Answer Correct Answer: A) Recovery. 18. Duplicate values can be entered in primary key.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: B) B. False. 19. The figure below is an example of a(n): A) Supertype/subtype hierarchy. B) Hierarchical data model. C) Entity cluster. D) Column cluster. Show Answer Correct Answer: A) Supertype/subtype hierarchy. 20. What is a disadvantage of using a DBMS? A) Complexity B) Easy to use C) Low cost D) High performance A) A. B) Scalability issues. C) Affordable maintenance. D) User-friendly interface. Show Answer Correct Answer: A) A. 21. Which of the following is not the type of the data model? A) Relational Data Model. B) Object Oriented Model. C) Entity-Relationship Model. D) Process-based Data Model. Show Answer Correct Answer: D) Process-based Data Model. 22. Which of the following are introduced to reduce the overheads caused by the log-based recovery? A) Checkpoints. B) Indices. C) Deadlocks. D) Locks. Show Answer Correct Answer: A) Checkpoints. 23. The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 24. Which DBMS does Bank of America use to manage transaction processing? A) Amazon DynamoDB. B) IBM Db2. C) PostgreSQL. D) Snowflake. Show Answer Correct Answer: B) IBM Db2. 25. Is a file-based system suitable for a small sari-sari store? A) Yes, because it is cost-effective. B) No, because it wastes storage. C) Yes, because it is faster than DBMS. D) No, because it cannot handle text. Show Answer Correct Answer: A) Yes, because it is cost-effective. ← 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