This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 35 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 35 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the primary key in a database table? A) The average value of all the records in the table. B) The first column in the table. C) A unique identifier for each record in the table. D) The most frequently occurring value in the table. Show Answer Correct Answer: C) A unique identifier for each record in the table. 2. Which of the following is a type of query in MS Access? A) Data Query Language (DQL). B) Select Query. C) Data Definition Language (DDL). D) Data Control Language (DCL). Show Answer Correct Answer: B) Select Query. 3. ..... Key uniquely identifies each record in table. A) Fields. B) Record. C) Row. D) Primary. Show Answer Correct Answer: D) Primary. 4. What does the WHERE clause do in an SQL statement? A) Limits the number of rows returned. B) Specifies the conditions for data retrieval. C) Groups rows that have the same values. D) Orders the result set. Show Answer Correct Answer: B) Specifies the conditions for data retrieval. 5. What are the types of data integrity constraints? A) Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity. B) Data Redundancy. C) Data Normalization. D) Data Encryption. Show Answer Correct Answer: A) Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity. 6. ..... is a database that supports data distributed across several different sites A) Centralized database. B) Distributed database. C) Enterprise database. D) Discipline specific database. Show Answer Correct Answer: B) Distributed database. 7. Which of the following is not a database programs? A) MySQL. B) Oracle. C) Writer. D) OObase. Show Answer Correct Answer: C) Writer. 8. A Teacher can handle many Subjects, while a Subject can also be handled by many Teachers. Which ERD correctly shows this relationship? A) Teacher-One-to-One-Section. B) Teacher-One-to-Many-Subject. C) Teacher-Many-to-Many-Subject. D) Teacher-Recursive. Show Answer Correct Answer: C) Teacher-Many-to-Many-Subject. 9. What is a disadvantage of database systems? A) Increased costs. B) Improved data sharing. C) Reduced data redundancy. D) Enhanced data integrity. Show Answer Correct Answer: A) Increased costs. 10. Which of the following is an advantage of using a DBMS over a traditional file system? A) Increased data redundancy. B) Improved data security. C) Higher data inconsistency. D) Manual data backup. Show Answer Correct Answer: B) Improved data security. 11. What functions can be performed on a database? A) Queries and Updates. B) Queries and Deletions. C) Updates and Inserts. D) Queries, Updates, and Deletes. Show Answer Correct Answer: D) Queries, Updates, and Deletes. 12. A deadlock exists in the system if and only if the wait-for graph contains a ..... A) Cycle. B) Direction. C) Bi-direction. D) Rotation. Show Answer Correct Answer: A) Cycle. 13. Which of the following is a characteristic of the Object-Oriented DBMS? A) Does not support relationships. B) Is based on a hierarchical structure. C) Supports complex data types and inheritance. D) Uses tables to store data. Show Answer Correct Answer: C) Supports complex data types and inheritance. 14. The ..... rule specifies that an entity can be a member of only one subtype at a time. A) Exclusion. B) Disjoint. C) Removal. D) Inclusion. Show Answer Correct Answer: B) Disjoint. 15. In the relation model, the relation are generally termed as ..... A) Tuples. B) Attributes. C) Rows. D) Tables. Show Answer Correct Answer: D) Tables. 16. Which of the following is a benefit of using a cloud database? A) Higher maintenance costs. B) Limited access to data. C) Scalability and flexibility. D) Increased physical storage requirements. Show Answer Correct Answer: C) Scalability and flexibility. 17. What is the purpose of a view in SQL? A) To provide a virtual table based on the result set of a query. B) To delete records from a table. C) To create a new database. D) To insert records into a table. Show Answer Correct Answer: A) To provide a virtual table based on the result set of a query. 18. If a website developer wants to create a form where users can input their email and submit it, then which HTML tag should he/she use? A) . B) . C) . D) . Show Answer Correct Answer: A) . 19. Which of the following best describes a relational database? A) Data is stored in a flat file. B) Data is organized in tables with relationships. C) Data is stored in a tree structure. D) Data is stored in a single file. Show Answer Correct Answer: B) Data is organized in tables with relationships. 20. What are Keys? A) A DBMS key is an attribute or set of an attribute which helps you to identify a row(tuple) in a relation(table). B) Keys help you uniquely identify a row in a table by a combination of one or more columns in that table. C) They allow you to find the relation between two tables. D) All of the above. Show Answer Correct Answer: D) All of the above. 21. How do you update a record in SQL? A) UPDATE table name SET column1 = value1, column2 = value2 WHERE condition;. B) SELECT * FROM table name WHERE condition;. C) DELETE FROM table name WHERE condition;. D) INSERT INTO table name VALUES (value1, value2);. Show Answer Correct Answer: A) UPDATE table name SET column1 = value1, column2 = value2 WHERE condition;. 22. What is a performance-related disadvantage of a DBMS? A) Optimal performance for all applications. B) Increased concurrency control. C) Improved data accessibility and responsiveness. D) Decreased speed for some applications. Show Answer Correct Answer: D) Decreased speed for some applications. 23. What is a view in SQL and how is it different from a table? A) A view is a physical table that stores data permanently. B) A view can only be created from a single table. C) A view is a type of database index that speeds up queries. D) A view is a virtual table based on a SELECT query, while a table is a physical storage of data. Show Answer Correct Answer: D) A view is a virtual table based on a SELECT query, while a table is a physical storage of data. 24. Which of the following types of database users interacts directly with the database? A) Database administrators. B) End users. C) Application programmers. D) System analysts. Show Answer Correct Answer: B) End users. 25. In the ..... normal form, a composite attribute is converted to individual attributes A) First Normal Form. B) Second Normal Form. C) Third Normal Form. D) Fourth Normal Form. Show Answer Correct Answer: A) First Normal Form. ← 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