This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 14 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 14 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is NOT example of data? A) RM10. B) The. C) The boy received RM10. D) Boy. Show Answer Correct Answer: C) The boy received RM10. 2. Data Integrity means that data is accurate and consistent in the database.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: A) A. True. 3. What is the most common classification applied to a DBMS? A) Number of users. B) Database site location(s). C) Expected type and extent of use. D) Software manufacturer. Show Answer Correct Answer: C) Expected type and extent of use. 4. What does a Database Management System (DBMS) do? A) Creates user interfaces. B) Only stores data. C) Performs data analysis. D) Interacts with and manages data in the database. Show Answer Correct Answer: D) Interacts with and manages data in the database. 5. A/an ..... is a database that is created and maintained using cloud data services, such as Microsoft Azure or Amazon AWS. A) Data warehouse. B) Cloud database. C) Unstructure database. D) Centralized database. Show Answer Correct Answer: B) Cloud database. 6. A database developer decides to add an index to the 'zip code' column in a large 'customers' table. What is the primary reason for this action? A) To increase the total amount of data stored in the database. B) To prevent unauthorized users from viewing the data. C) To improve the performance of queries that search for customers in a specific zip code. D) To enforce a unique constraint on the zip code values. Show Answer Correct Answer: C) To improve the performance of queries that search for customers in a specific zip code. 7. Explain the first normal form (1NF). A) First Normal Form (1NF) allows duplicate values in columns. B) 1NF requires that all data types in a column be the same. C) First Normal Form (1NF) is only applicable to relational databases. D) First Normal Form (1NF) is a property of a relation in a database that ensures all columns contain atomic values and each column has a unique name. Show Answer Correct Answer: D) First Normal Form (1NF) is a property of a relation in a database that ensures all columns contain atomic values and each column has a unique name. 8. Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 9. What is the role of the data dictionary in a DBMS? A) To store actual data records. B) To store metadata about the structure of the database. C) To process user queries. D) To print reports. Show Answer Correct Answer: B) To store metadata about the structure of the database. 10. Which SQL statement is used to update existing data in a table? A) CHANGE. B) MODIFY. C) UPDATE. D) ALTER. Show Answer Correct Answer: C) UPDATE. 11. Why is it important to reconcile data discrepancies in healthcare? A) It helps doctors make quick decisions, even if the decision is sometimes inaccurate. B) It ensures that doctors make the right decisions based on correct information. C) It simplifies workflows by ignoring small errors in records. D) It allows treatments to continue without checking for data errors. Show Answer Correct Answer: B) It ensures that doctors make the right decisions based on correct information. 12. ..... :Builds applications that use the database. A) Developer. B) Database. C) Server. D) User. Show Answer Correct Answer: A) Developer. 13. In a relational model, an attribute refers to: A) A column in a table. B) A row in a table. C) The table name. D) The relationship between two tables. Show Answer Correct Answer: A) A column in a table. 14. What is an example of a hierarchical DBMS? A) File system B) XML database C) SQL database D) Object-oriented database A) Relational database. B) Flat file database. C) NoSQL database. D) XML database. Show Answer Correct Answer: D) XML database. 15. Which of the following in not a function of DBA? A) Network Maintenance. B) Routine Maintenance. C) Schema Definition. D) Authorization for data access. Show Answer Correct Answer: A) Network Maintenance. 16. What is a benefit of sharing data in a DBMS? A) Increased data redundancy. B) Limited access to data for security. C) Improved data integrity. D) More users can access and share data. Show Answer Correct Answer: D) More users can access and share data. 17. Name one advantage of using a DBMS over file systems. A) Lower cost of storage compared to DBMS. B) Data integrity and consistency management. C) Better support for complex queries than DBMS. D) Easier data retrieval than DBMS. Show Answer Correct Answer: B) Data integrity and consistency management. 18. What models an enterprise as a collection of entities and relationships? A) Relational model. B) Entity-Relationship data model. C) Object-based data models. D) None of the above. Show Answer Correct Answer: B) Entity-Relationship data model. 19. Which of the following are the properties of entities? A) Groups. B) Tables. C) Attributes. D) Switchboards. Show Answer Correct Answer: C) Attributes. 20. What is the purpose of a unique constraint in SQL? A) To ensure all rows in a table can have identical values. B) To prevent duplicate entries in a column that is not a primary key. C) To link two tables together. D) To automatically update data in a table. Show Answer Correct Answer: B) To prevent duplicate entries in a column that is not a primary key. 21. What is the purpose of commit control in a distributed DBMS? A) To ensure data integrity during real-time operations. B) To simplify data retrieval processes. C) To allow users to bypass data checks. D) To eliminate the need for data replication. Show Answer Correct Answer: A) To ensure data integrity during real-time operations. 22. What are some common types of database management systems? A) Flat-file, Graph, Document-oriented, Key-value. B) Relational, In-memory, Time-series, Network. C) Relational, NoSQL, Object-oriented, Hierarchical. D) Object-oriented, Columnar, Spatial, Multi-model. Show Answer Correct Answer: C) Relational, NoSQL, Object-oriented, Hierarchical. 23. Write an SQL query to update a record in the 'Students' table. A) INSERT INTO Students (column name) VALUES (new value);. B) UPDATE Students SET column name = new value WHERE condition;. C) SELECT * FROM Students WHERE condition;. D) DELETE FROM Students WHERE condition;. Show Answer Correct Answer: B) UPDATE Students SET column name = new value WHERE condition;. 24. Which DBMS user has no technical knowledge and uses pre-defined menus? A) DBA. B) Application Programmer. C) Online User. D) Naive User. Show Answer Correct Answer: D) Naive User. 25. Explain the concept of normalization in RDBMS. A) The process of increasing redundancy in a database. B) The process of encrypting data in a database. C) The process of organizing data in a database to reduce redundancy and dependency. D) The process of deleting data from a database. Show Answer Correct Answer: C) The process of organizing data in a database to reduce redundancy and dependency. ← 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