This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 31 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 31 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is a data integrity constraint? A) Data redundancy. B) Data inconsistency. C) Primary key. D) Data duplication. Show Answer Correct Answer: C) Primary key. 2. Describe what a database schema is. A) A database schema is a type of software application. B) A database schema is a blueprint that outlines the structure of a database, including tables, fields, data types, and relationships. C) A database schema is a collection of user accounts and permissions. D) A database schema is a programming language used for data manipulation. Show Answer Correct Answer: B) A database schema is a blueprint that outlines the structure of a database, including tables, fields, data types, and relationships. 3. ..... :Law protecting student education records. A) FERPA. B) HIPAA. C) FOIA. D) ADA. Show Answer Correct Answer: A) FERPA. 4. In a library DBMS, which is part of the external level? A) How data is physically stored. B) User views showing only book titles and authors. C) System catalog of metadata. D) Database buffers. Show Answer Correct Answer: B) User views showing only book titles and authors. 5. How does the cost of conversion impact organizations using a DBMS? A) It does not require training staff to use new systems. B) It is relatively small compared to the cost of the DBMS. C) It includes the cost of converting existing applications. D) It does not involve specialist staff for conversion. Show Answer Correct Answer: C) It includes the cost of converting existing applications. 6. What is the main advantage of indexing in a database? A) Reduces storage space. B) Speeds up data retrieval. C) Simplifies the database structure. D) Increases data redundancy. Show Answer Correct Answer: B) Speeds up data retrieval. 7. Which SQL statement is used to add a new row to a table? A) INSERT INTO. B) ADD ROW. C) ADD INTO. D) INSERT ROW. Show Answer Correct Answer: A) INSERT INTO. 8. Which SQL command is used to modify existing data within a table? A) SELECT. B) INSERT. C) UPDATE. D) DELETE. Show Answer Correct Answer: C) UPDATE. 9. Lost Update Problem:When one transaction ..... updates made by another transaction. A) Overwrites. B) Reads. C) Ignores. D) Commits. Show Answer Correct Answer: A) Overwrites. 10. Which book is referenced in the resources section? A) Database Systems:A Practical Approach. B) Fundamentals of Database Design. C) Introduction to Database Systems. D) Modern Database Management Eleventh Edition. Show Answer Correct Answer: D) Modern Database Management Eleventh Edition. 11. Graph databases are ideal for social network analysis. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 12. What does data consistency refer to in the context of a DBMS? A) Allowing multiple versions of the same data. B) Ensuring data is stored only once in the database. C) Storing data redundantly for backup. D) Providing data access to unauthorized users. Show Answer Correct Answer: B) Ensuring data is stored only once in the database. 13. In an ERD, what symbol is typically used to represent an entity? A) Rectangle. B) Circle. C) Diamond. D) Triangle. Show Answer Correct Answer: A) Rectangle. 14. A workgroup database is best described as: A) A multi-user database that supports a small group of users or a single department. B) A database used only by one person. C) A database that supports an entire organization. D) A database for storing multimedia files. Show Answer Correct Answer: A) A multi-user database that supports a small group of users or a single department. 15. In SQL, what does the JOIN operation do? A) Combines rows from two or more tables. B) Deletes rows from a table. C) Updates rows in a table. D) Creates a new table. Show Answer Correct Answer: A) Combines rows from two or more tables. 16. What is the purpose of a data warehouse? A) Store data for day-to-day operations. B) Support decision-making processes by providing a consolidated view of historical data. C) Manage data access permissions. D) Perform real-time data analysis. Show Answer Correct Answer: B) Support decision-making processes by providing a consolidated view of historical data. 17. Time-series databases are optimized for storing historical data. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 18. Data mining is primarily concerned with: A) Storing and retrieving data. B) Analyzing and discovering patterns in large datasets. C) Creating graphical representations of data. D) Securing data from unauthorized access. Show Answer Correct Answer: B) Analyzing and discovering patterns in large datasets. 19. What is data replication in the context of distributed databases? A) Partitioning data into smaller segments. B) Storing a single copy of the database. C) Distributing data only horizontally. D) Creating separate copies of the database at multiple sites. Show Answer Correct Answer: D) Creating separate copies of the database at multiple sites. 20. What is the name for an answer to a query that the DBMS sends back to the application? A) DBMS result. B) Query result set. C) Question result. D) Data result. Show Answer Correct Answer: B) Query result set. 21. Consider attributes ID, CITY and NAME. which one of these can be considered as a primary key? A) NAME. B) ID. C) CITY. D) ID, NAME. Show Answer Correct Answer: B) ID. 22. What is NOT a characteristic of big data? A) Volume. B) Variety. C) Vision. D) Velocity. Show Answer Correct Answer: C) Vision. 23. What is a limitation of using a DBMS for small tasks? A) It is always more efficient. B) Overhead is unnecessary for tiny one-off tasks. C) It requires complex queries. D) It is less secure. Show Answer Correct Answer: B) Overhead is unnecessary for tiny one-off tasks. 24. Which of the following is NOT an advantage of DBMS? A) Data Security. B) Data Integrity. C) High Performance in all cases. D) Centralized Control. Show Answer Correct Answer: C) High Performance in all cases. 25. What is the Composite key? A) A key which has multiple attributes to uniquely identify rows in a table. B) Any part of the compound key can be a foreign key. C) The composite key may or may not be a part of the foreign key. 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