This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 58 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 58 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... are considered database architects. A) Database administrators. B) Systems administrators. C) Database designers. D) Systems analysts and programmers. Show Answer Correct Answer: A) Database administrators. 2. What is the primary purpose of locking mechanisms in database systems? A) Locking mechanisms are used to speed up data retrieval. B) Locking mechanisms prevent unauthorized access to the database. C) Locking mechanisms ensure that only one transaction can modify data at a time to prevent conflicts. D) Locking mechanisms are only relevant for large databases. Show Answer Correct Answer: C) Locking mechanisms ensure that only one transaction can modify data at a time to prevent conflicts. 3. What is the purpose of the PROJECT operation in relational algebra? A) Combine rows from different tables. B) Filter rows based on a condition. C) Remove unwanted columns from a table. D) Sort the table in ascending order. Show Answer Correct Answer: C) Remove unwanted columns from a table. 4. Communication is established with MySQL using A) SQL. B) Network calls. C) Java. D) API's. Show Answer Correct Answer: A) SQL. 5. Which is not a feature of database software? A) Tables. B) Queries. C) Filters. D) Cropping. Show Answer Correct Answer: D) Cropping. 6. Which of the following is a fundamental relational algebra operation? A) Join. B) Aggregate. C) Project. D) Update. Show Answer Correct Answer: C) Project. 7. A database for a blog stores posts and comments. A single post can have MANY comments, but each comment belongs to ONLY ONE post. To model this, a POSTS table with PostID and a COMMENTS table with CommentID and a PostID foreign key are created. This database design is an example of what kind of relationship? A) Many-to-many (M:N). B) One-to-one (1:1). C) One-to-many (1:M). D) A composite relationship. Show Answer Correct Answer: C) One-to-many (1:M). 8. The ..... rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. A) Semi-specialization. B) Total specialization. C) Partial specialization. D) Disjointness. Show Answer Correct Answer: C) Partial specialization. 9. Data warehouses are used for real-time data processing. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 10. Which additional relational algebra operation is used to combine rows from two tables? A) Union. B) Join. C) Project. D) Intersect. Show Answer Correct Answer: B) Join. 11. Log (Journal):A file that records all ..... activity. A) Transaction. B) Network. C) User. D) System. Show Answer Correct Answer: A) Transaction. 12. In the context of ACID properties, what does "Atomicity" primarily ensure? A) Data is permanently stored. B) Transactions are completed entirely or not at all. C) Concurrent transactions do not interfere. D) Database remains in a consistent state. Show Answer Correct Answer: B) Transactions are completed entirely or not at all. 13. Which of the following methods enforce data integrity. A) Constraints. B) Triggers. C) Procedure. D) Both a and b. Show Answer Correct Answer: D) Both a and b. 14. Which one of the following types of database schema is used for organizing data in single, two dimensional displays? A) Flat model. B) Hierarchical model. C) Network model. D) Relational model. Show Answer Correct Answer: A) Flat model. 15. Which key is a combination of two or more attributes that uniquely identify a row? A) Super key. B) Candidate key. C) Composite key. D) Foreign key. Show Answer Correct Answer: C) Composite key. 16. ..... :Preventing discrimination in data use. A) Fairness. B) Accuracy. C) Privacy. D) Transparency. Show Answer Correct Answer: A) Fairness. 17. What is a primary key constraint? A) A rule that defines data types. B) A rule that links tables. C) A rule that ensures uniqueness. D) A rule that allows null values. Show Answer Correct Answer: C) A rule that ensures uniqueness. 18. Which of the following SQL statements is used to delete specific records from a table? A) REMOVE. B) DELETE. C) DROP. D) ERASE. Show Answer Correct Answer: B) DELETE. 19. In MS Access, what is the purpose of a form? A) To store data. B) To input and display data. C) To delete data. D) To create queries. Show Answer Correct Answer: B) To input and display data. 20. What is an example of a multi-value attribute? A) Name. B) Phone numbers. C) Age. D) Address. Show Answer Correct Answer: B) Phone numbers. 21. RDBMS supports horizontal scaling easily. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 22. Which of the following is NOT a type of DBMS? A) Relational DBMS. B) Network DBMS. C) Linear DBMS. D) Hierarchical DBMS. Show Answer Correct Answer: C) Linear DBMS. 23. What are the advantages of using a database system over a file system? A) Limited data sharing capabilities. B) Inflexible data formats. C) Advantages of using a database system over a file system include structured data management, support for complex queries, data integrity, concurrent access, efficient data retrieval, and enhanced security. D) Slower data processing speeds. Show Answer Correct Answer: C) Advantages of using a database system over a file system include structured data management, support for complex queries, data integrity, concurrent access, efficient data retrieval, and enhanced security. 24. Which topology the failure one computer affects the entire network? A) Ring. B) Bus. C) Star. D) Mesh. Show Answer Correct Answer: A) Ring. 25. Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released? A) Record controller. B) Exclusive lock. C) Authorization rule. D) Two phase lock. Show Answer Correct Answer: D) Two phase lock. ← 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