This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 25 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 25 (20 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Client Role:Handles the ..... interface. A) User. B) Database. C) Network. D) Server. Show Answer Correct Answer: A) User. 2. ..... :A standard interface that allows applications to connect to different DBMSs. A) API. B) JDBC. C) SQL. D) ODBC. Show Answer Correct Answer: D) ODBC. 3. In packaged data models, all subtype/supertype relationships follow the ..... and ..... rules. A) Total specialization; disjoint. B) Partial specialization; overlap. C) Partial specialization; disjoint. D) Total specialization; overlap. Show Answer Correct Answer: D) Total specialization; overlap. 4. Which language is used to define database structure? A) DCL. B) DDL. C) DML. D) TCL. Show Answer Correct Answer: B) DDL. 5. Data Manipulation Language enables users to A) Retrieval of information stored in database. B) Insertion of new information into the database. C) Deletion of information from the database. D) All of the above. Show Answer Correct Answer: D) All of the above. 6. An entity cluster can be formed by: A) Deleting a supertype and its subtype. B) Combining metadata. C) Combining a strong entity and its weak entities. D) Deleting metadata. Show Answer Correct Answer: C) Combining a strong entity and its weak entities. 7. What is the purpose of a surrogate key in a database? A) To allow NULL values in a relation. B) To uniquely identify records without using natural keys. C) To enforce referential integrity. D) To define the structure of a table. Show Answer Correct Answer: B) To uniquely identify records without using natural keys. 8. In database recovery, what is the primary role of the Write-Ahead Logging (WAL) protocol? A) Stores logs before writing actual data to prevent data loss. B) Ensures that all transactions are committed at once. C) Locks database tables during updates. D) Checks query execution speed. Show Answer Correct Answer: A) Stores logs before writing actual data to prevent data loss. 9. Disadvantages of File systems to store data is: A) Data redundancy and inconsistency. B) Difficulty in accessing data. C) Data isolation. D) All of the above. Show Answer Correct Answer: D) All of the above. 10. Explain the concept of tables in RDBMS. A) Tables in RDBMS store data in an unstructured format with no specific organization. B) Tables in RDBMS store data in a structured format with rows and columns. C) Tables in RDBMS are used to store only text data and cannot handle other data types. D) Tables in RDBMS do not have rows and columns, but instead store data in a single continuous block. Show Answer Correct Answer: B) Tables in RDBMS store data in a structured format with rows and columns. 11. A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is: A) Data analysis. B) Data profiling. C) User interviews. D) Data volume usage analysis. Show Answer Correct Answer: B) Data profiling. 12. Non-Serial Schedule:Transactions execute concurrently with ..... operations. A) Interleaving. B) Isolated. C) Sequential. D) Atomic. Show Answer Correct Answer: A) Interleaving. 13. What does the term "modification of the database" refer to? A) Querying the database. B) Updating, inserting, or deleting records in the database. C) Creating a backup of the database. D) Changing the database schema. Show Answer Correct Answer: B) Updating, inserting, or deleting records in the database. 14. What does the term 'data inconsistency' mean? A) Data is stored in multiple formats. B) Data is encrypted for security. C) Data is lost due to system failure. D) Data values do not match across different files. Show Answer Correct Answer: D) Data values do not match across different files. 15. What is the main function of back-end database components? A) To create user-friendly interfaces. B) To present data to users. C) To handle server-side logic and data processing. D) To perform data validation. Show Answer Correct Answer: C) To handle server-side logic and data processing. 16. Suatu sistem penyusunan dan pengelolaan record-record dengan menggunakan komputer, dengan tujuan untuk menyimpan atau merekam serta memelihara data operasional lengkap sebuah organisasi/perusahaan sehingga mampu menyediakan informasi yang diperlukan pemakai untuk kepentingan proses pengambilan keputusan. A) Database Systems. B) Komponen Dasar dari Sistem Database. C) Database. D) Sistem Informasi Akuntansi. Show Answer Correct Answer: A) Database Systems. 17. Which of the following is true of packaged data models? A) Relationships are connected to the highest-level entity type in an order that makes sense. B) All subtype/supertype relationships follow the total specialization and disjoint rules. C) No entities on the many sides of a relationship can be weak. D) All weak entities are considered strong. Show Answer Correct Answer: A) Relationships are connected to the highest-level entity type in an order that makes sense. 18. What is the main advantage of using a DBMS over a file processing system? A) Reduces data redundancy and improves data integrity. B) Is less complex. C) Is easier to implement. D) Requires less memory. Show Answer Correct Answer: A) Reduces data redundancy and improves data integrity. 19. If a company wants to store its data in multiple locations for redundancy, which type of database should it use? A) Centralized. B) Object-oriented. C) Distributed. D) Flat-file. Show Answer Correct Answer: C) Distributed. 20. How do entities and attributes relate to data models? A) Entities are objects in data models, and attributes are their properties. B) Entities and attributes have no significance in data models. C) Attributes are the relationships between entities. D) Entities are only used in relational databases. Show Answer Correct Answer: A) Entities are objects in data models, and attributes are their properties. ← PreviousRelated QuizzesScience QuizzesClass 12 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books