This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 1 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 1 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... :Rules that ensure data accuracy. A) Integrity Constraints. B) Primary Keys. C) Foreign Keys. D) Normalization. Show Answer Correct Answer: A) Integrity Constraints. 2. In MS Access, which object is used to retrieve and analyze data? A) Table. B) Form. C) Query. D) Report. Show Answer Correct Answer: C) Query. 3. Which of the following is a front-end database component? A) User Interface (UI). B) Server-Side Logic. C) Database Management. D) APIs. Show Answer Correct Answer: A) User Interface (UI). 4. What is a report in MS Access used for? A) To input data. B) To modify database structure. C) To present data in a printable format. D) To delete records. Show Answer Correct Answer: C) To present data in a printable format. 5. What does normalization in a database refer to? A) Reducing data redundancy. B) Enhancing data security. C) Increasing data duplication. D) Creating backup copies. Show Answer Correct Answer: A) Reducing data redundancy. 6. Which DBMS is used by Uber for real-time tracking of rides? A) Cassandra. B) MongoDB. C) SQLite. D) Neo4j. Show Answer Correct Answer: B) MongoDB. 7. What practice is crucial for maintaining the confidentiality of patient records in a hospital's database? A) Sharing passwords among staff. B) Implementing strong access controls and encryption. C) Allowing open access to all hospital staff. D) Storing data in plain text for easy access. Show Answer Correct Answer: B) Implementing strong access controls and encryption. 8. In an ER diagram, a diamond shape is used to represent a: A) Entity. B) Attribute. C) Relationship. D) Key. Show Answer Correct Answer: C) Relationship. 9. Suppose a company wants to add a new field to its employee records. What is a likely consequence in a traditional file system? A) No changes are needed to application programs. B) All application programs using the file must be modified and recompiled. C) The new field is automatically added to all records. D) The file system updates itself. Show Answer Correct Answer: B) All application programs using the file must be modified and recompiled. 10. Which criteria will produce an alphabetical list of drivers who have 150 points? A) >150 and Sort Ascending. B) >150 and Sort Descending. C) >=150 and Sort Ascending. D) >=150 and Sort Descending. Show Answer Correct Answer: C) >=150 and Sort Ascending. 11. What is a normalization process in databases? A) Encrypting data. B) Creating backups. C) Reducing redundancy. D) Combining tables. Show Answer Correct Answer: C) Reducing redundancy. 12. What is the purpose of the JOIN clause in SQL? A) To combine rows from two or more tables based on a related column. B) To filter records based on specified conditions. C) To sort the result set in ascending order. D) To create a new table in the database. Show Answer Correct Answer: A) To combine rows from two or more tables based on a related column. 13. What is denormalization? A) Denormalization is the process of removing redundancy from a database. B) Denormalization refers to the normalization of data in a database. C) Denormalization is a method to encrypt sensitive data in a database. D) Denormalization is the process of optimizing the read performance of a database by intentionally introducing redundancy into the data. Show Answer Correct Answer: D) Denormalization is the process of optimizing the read performance of a database by intentionally introducing redundancy into the data. 14. Describe the process of converting a database to 3NF. A) The process involves ensuring the database is in 2NF, identifying functional dependencies, removing transitive dependencies, creating new tables, and establishing foreign key relationships. B) 3NF can be achieved by simply deleting all duplicate records. C) The process involves merging all tables into one. D) Converting a database to 3NF requires only adding indexes. Show Answer Correct Answer: A) The process involves ensuring the database is in 2NF, identifying functional dependencies, removing transitive dependencies, creating new tables, and establishing foreign key relationships. 15. What is the primary function of a foreign key in a database? A) To encrypt sensitive information. B) To uniquely identify a record. C) To store large amounts of data. D) To establish a relationship between two tables. Show Answer Correct Answer: D) To establish a relationship between two tables. 16. Which of the following is not a function of DML? A) INSERT. B) ALTER TABLE. C) DELETE. D) UPDATE. Show Answer Correct Answer: B) ALTER TABLE. 17. What is the Compound key? A) Compound key has many fields which allow you to uniquely recognize a specific record. B) Each column may not be unique by itself within the database. C) The combination of composite keys become unique. D) All of the above. Show Answer Correct Answer: D) All of the above. 18. What is the purpose of the INDEX keyword in SQL? A) To create a backup of the database. B) To enhance the performance of queries by allowing faster data retrieval. C) To define a new table in a database. D) To delete records from a table. Show Answer Correct Answer: B) To enhance the performance of queries by allowing faster data retrieval. 19. The ..... clause allows us to select only those rows in the result which that satisfy a specified condition/predicate. A) Where. B) Having. C) Select. D) From. Show Answer Correct Answer: A) Where. 20. In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ..... rule. A) Disjoint. B) Specialization. C) Generalization. D) Overlap. Show Answer Correct Answer: A) Disjoint. 21. What ensures foreign keys match with primary keys or are NULL? A) Domain Constraint. B) Referential Integrity. C) Entity Integrity. D) Atomic Constraint. Show Answer Correct Answer: B) Referential Integrity. 22. An attribute of the supertype that determines the target subtype(s) is called the: A) Determinant. B) Subtype decision. C) Disjoint indicator. D) Subtype discriminator. Show Answer Correct Answer: D) Subtype discriminator. 23. What is the result of a union operation in relational algebra? A) Renames a relation. B) Finds common records. C) Subtracts one relation from another. D) Combines two relations. Show Answer Correct Answer: D) Combines two relations. 24. What is the main purpose of AJAX in web development? A) Load data asynchronously without reloading the page. B) Improve website aesthetics. C) Encrypt web traffic. D) Validate form data. Show Answer Correct Answer: A) Load data asynchronously without reloading the page. 25. Microsoft Access is most commonly used by which of the following? A) Large retail chains. B) Small businesses. C) Airlines. D) E-commerce websites. Show Answer Correct Answer: B) Small businesses. Next →Related QuizzesClass 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 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books