This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 37 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 37 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In the hierarchical model, how is data organized? A) As an inverted tree. B) In a graph. C) In two-dimensional tables. D) None of the above. Show Answer Correct Answer: A) As an inverted tree. 2. What is a multi-valued attribute in a relational schema? A) An attribute that cannot be NULL. B) An attribute that can have multiple values. C) An attribute that is unique for each tuple. D) An attribute that references another table. Show Answer Correct Answer: B) An attribute that can have multiple values. 3. Which mode of transmission sender act as sender and act as receiver after some time interval? A) Simplex. B) Half duplex. C) Full duplex. D) Unidirectional. Show Answer Correct Answer: B) Half duplex. 4. What is the primary purpose of the ER Model? A) To optimize database performance through indexing. B) To store data in a flat file format. C) To ensure data security and privacy. D) To visually represent data structure and relationships in a database. Show Answer Correct Answer: D) To visually represent data structure and relationships in a database. 5. Deadlock:When two transactions wait for each other's locks and cannot ..... A) Proceed. B) Communicate. C) Rollback. D) Commit. Show Answer Correct Answer: A) Proceed. 6. Describe a recovery algorithm used in database management. A) Shadow Paging. B) Database Replication Method. C) Two-Phase Commit Protocol. D) Write-Ahead Logging (WAL) protocol. Show Answer Correct Answer: D) Write-Ahead Logging (WAL) protocol. 7. Which database concept ensures that relationships between tables remain valid? A) Referential integrity. B) Data redundancy. C) Query processing. D) Logical schema. Show Answer Correct Answer: A) Referential integrity. 8. How does a DBMS handle data transformation and presentation? A) By translating logical requests into commands to physically locate and retrieve the requested data. B) By compressing data for storage. C) By generating random data for testing. D) By deleting obsolete data automatically. Show Answer Correct Answer: A) By translating logical requests into commands to physically locate and retrieve the requested data. 9. What is the main difference between SQL and NoSQL databases? A) SQL databases are unstructured. B) NoSQL databases are always faster. C) NoSQL databases support complex queries. D) SQL databases use a fixed schema. Show Answer Correct Answer: D) SQL databases use a fixed schema. 10. Processed data, or ..... , can be used as the basis for decision making. A) Raw data. B) Information. C) Queries. D) DP. Show Answer Correct Answer: B) Information. 11. Explain the use of the WHERE clause in SQL queries. A) The WHERE clause is used to join multiple tables in SQL queries. B) The WHERE clause is used to aggregate data in SQL queries. C) The WHERE clause is used to filter records in SQL queries based on specified conditions. D) The WHERE clause is used to sort records in SQL queries. Show Answer Correct Answer: C) The WHERE clause is used to filter records in SQL queries based on specified conditions. 12. What level of data and process distribution describes a system where all processing and data storage occur on a single computer? A) SPSD. B) MPSD. C) MPMD. D) DPMS. Show Answer Correct Answer: A) SPSD. 13. In a crop yield database, which field should ideally serve as the primary key? A) Farmer Name. B) Crop Type. C) Farm ID or Crop ID. D) Yield Value. Show Answer Correct Answer: C) Farm ID or Crop ID. 14. What is an additional cost that may arise from using a DBMS? A) Decreased need for additional hardware. B) Reduced storage space requirements. C) Purchase of more storage space. D) No impact on hardware performance. Show Answer Correct Answer: C) Purchase of more storage space. 15. Which property ensures that database transactions maintain a consistent state? A) Atomicity. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: B) Consistency. 16. Which of the following best describes a weak entity? A) An entity that has a primary key. B) An entity with no attributes. C) An entity that cannot be uniquely identified without a strong entity. D) An entity that can exist independently. Show Answer Correct Answer: C) An entity that cannot be uniquely identified without a strong entity. 17. What is a benefit of using a DBMS? A) They provide full security to data using private/public key encryption. B) They create automatic backups. C) They help create an environment for end users to have access to more data. D) They provide seamless Internet access to database data. Show Answer Correct Answer: B) They create automatic backups. 18. In an ERD, what does cardinality specify? A) The attributes of an entity. B) The number of instances of an entity related to another entity. C) The primary keys of a table. D) The foreign keys of a table. Show Answer Correct Answer: B) The number of instances of an entity related to another entity. 19. What is the purpose of the UNIQUE constraint? A) To create a backup. B) To link multiple tables. C) To ensure all values are different. D) To allow duplicate values. Show Answer Correct Answer: C) To ensure all values are different. 20. Which of the following ensures only authorized users can access specific data in a DBMS? A) User authentication and access rights. B) Data redundancy. C) Normalization. D) Logical schema. Show Answer Correct Answer: A) User authentication and access rights. 21. What is a disadvantage of the database approach related to performance? A) Greater impact of a failure. B) Improved backup and recovery services. C) Balanced conflicting requirements. D) Increased data consistency. Show Answer Correct Answer: A) Greater impact of a failure. 22. What is the significance of backup and recovery in DBMS? A) Backup and recovery are essential for data protection, integrity, and availability in a DBMS. B) Backup processes slow down database performance significantly. C) Recovery is only needed in case of hardware failure. D) Backup and recovery are only necessary for large databases. Show Answer Correct Answer: A) Backup and recovery are essential for data protection, integrity, and availability in a DBMS. 23. Which DBMS does Facebook use to store and access vast amounts of user data? A) MySQL. B) Oracle Database. C) SQLite. D) MongoDB. Show Answer Correct Answer: A) MySQL. 24. What are the common techniques for SQL query optimization? A) Common techniques for SQL query optimization include using indexes, rewriting queries, avoiding SELECT *, using appropriate JOINs, and analyzing execution plans. B) Ignoring database statistics. C) Using only aggregate functions. D) Relying solely on subqueries. Show Answer Correct Answer: A) Common techniques for SQL query optimization include using indexes, rewriting queries, avoiding SELECT *, using appropriate JOINs, and analyzing execution plans. 25. What is the primary function of a foreign key in a relational database? A) To uniquely identify a record. B) To create indexes for faster access. C) To establish a link between two tables. D) To store large amounts of data. Show Answer Correct Answer: C) To establish a link between two tables. ← 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