This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 18 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 18 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... :Data storage layer. A) Database Tier. B) Presentation Tier. C) Application Tier. D) Network Tier. Show Answer Correct Answer: A) Database Tier. 2. What is data independence in the context of DBMS? A) Data independence refers to the ability to access data without any restrictions. B) Data independence is the ability to change the database schema at one level without affecting other levels. C) Data independence is the process of securing data from unauthorized access. D) Data independence means having multiple copies of the same data. Show Answer Correct Answer: B) Data independence is the ability to change the database schema at one level without affecting other levels. 3. Why is it important to enforce data integrity in a database? A) It is important to enforce data integrity to maintain accuracy, consistency, and reliability of data in a database. B) Data integrity is irrelevant for temporary data storage. C) Enforcing data integrity slows down database performance. D) Data integrity is only important for large databases. Show Answer Correct Answer: A) It is important to enforce data integrity to maintain accuracy, consistency, and reliability of data in a database. 4. What does ER stand for in ER Diagrams? A) Entity Record. B) Entity Report. C) Entity Relation. D) Entity Relationship. Show Answer Correct Answer: D) Entity Relationship. 5. Which of the following is used in the application programs to request data from the database management system? A) Data Manipulation Language. B) Data Definition Language. C) Data Control Language. D) All of the above. Show Answer Correct Answer: A) Data Manipulation Language. 6. Which of the following is NOT a fundamental principle of database security? A) Authentication. B) Authorization. C) Encryption. D) Normalization. Show Answer Correct Answer: D) Normalization. 7. A Database Management System (DBMS) is A) Collection of interrelated data. B) Collection of programs to access data. C) Collection of data describing one particular enterprise. D) All of the above. Show Answer Correct Answer: D) All of the above. 8. What are the different types of DML commands? A) INSERT, UPDATE, REPLACE, SELECT. B) INSERT, UPDATE, DELETE, SELECT. C) CREATE, MODIFY, DROP, SELECT. D) INSERT, UPDATE, REMOVE, QUERY. Show Answer Correct Answer: B) INSERT, UPDATE, DELETE, SELECT. 9. Supertype/subtype relationships should not be used when the instances of a subtype participate in no relationships which are unique to that subtype. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 10. Which of the following database object produces the final result to present? A) Form. B) Report. C) Queries. D) Table. Show Answer Correct Answer: B) Report. 11. Which SQL statement is used to create a new database? A) CREATE DATABASE. B) MAKE DATABASE. C) NEW DATABASE. D) ADD DATABASE. Show Answer Correct Answer: A) CREATE DATABASE. 12. What does ACID stand for in the context of transactions? A) Accuracy, Clarity, Integrity, Dependability. B) Atomicity, Consistency, Isolation, Dependability. C) Atomicity, Consistency, Isolation, Durability. D) Atomicity, Concurrency, Isolation, Durability. Show Answer Correct Answer: C) Atomicity, Consistency, Isolation, Durability. 13. What is a limitation of a DBMS? A) Allows easy data sharing. B) Supports multiple formats. C) Requires admin/training to manage. D) Is always online. Show Answer Correct Answer: C) Requires admin/training to manage. 14. What are two key benefits of utilizing a Database Management System (DBMS)? A) Increased data inconsistency. B) Complex data management. C) Enhanced data security and backup options. D) Higher costs and maintenance requirements. Show Answer Correct Answer: C) Enhanced data security and backup options. 15. If we might write the following internet program, then what type of CSS is applying for displaying the text color in red? This is your exit exam! It should appear in red A) External. B) Internal. C) Inline. D) Browser default styles. Show Answer Correct Answer: C) Inline. 16. How does a DBMS handle multiple users accessing the database at the same time? A) By implementing concurrency control mechanisms. B) By preventing multiple users from accessing data. C) By deleting duplicate records. D) By storing data in separate files. Show Answer Correct Answer: A) By implementing concurrency control mechanisms. 17. What is the main benefit of modular growth in a distributed database? A) Increased complexity in data management. B) Ability to expand the database incrementally. C) Slower response to data requests. D) Reduced user control over data. Show Answer Correct Answer: B) Ability to expand the database incrementally. 18. Which approach is characterized by decentralized data management? A) File-Based Approach. B) Database Approach. C) Manual Approach. D) Cloud-Based Approach. Show Answer Correct Answer: A) File-Based Approach. 19. SQL is used for? A) Operating systems. B) Database management. C) Network security. D) Hardware control. Show Answer Correct Answer: B) Database management. 20. What are the main components of an ER model? A) Entities, Attributes, Relationships. B) Tables, Columns, Rows. C) Classes, Methods, Objects. D) Nodes, Edges, Weights. Show Answer Correct Answer: A) Entities, Attributes, Relationships. 21. What action should be taken to maintain data integrity in a hospital database? A) Delete all records older than a year. B) Allow unrestricted access to all users. C) Ignore obsolete records. D) Regularly update and back up the database. Show Answer Correct Answer: D) Regularly update and back up the database. 22. Which architecture separates the user interface from the database A) All of the above. B) Single-tier architecture. C) Two-tier architecture. D) Three-tier architecture. Show Answer Correct Answer: D) Three-tier architecture. 23. In a database transaction, what occurs if consistency rules are violated? A) Transaction is partially completed. B) Database continues normal operation. C) Entire transaction is rolled back. D) Only problematic data is removed. Show Answer Correct Answer: C) Entire transaction is rolled back. 24. What is data integrity? A) The accuracy and consistency of data. B) The speed of data retrieval. C) The amount of data stored. D) The security of data. Show Answer Correct Answer: A) The accuracy and consistency of data. 25. Which of the following is Database Language? A) Data Definition Language. B) Data Manipulation Language. C) Query Language. D) All of the above. Show Answer Correct Answer: D) All of the above. ← 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