This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 37 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 37 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The element of ERD that represents real-world things such as people, places, or events about which we want to store data is called: A) Attributes. B) Database. C) Relationship. D) Entities. Show Answer Correct Answer: D) Entities. 2. An ACID transaction is one that is: A) Atomic. B) Consistent. C) Isolated. D) Durable. E) All of the above. Show Answer Correct Answer: E) All of the above. 3. True or false:Can databases be a simple file or a complex set of related tables? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 4. All of the following are issues with the traditional file environment except ..... A) Data inconsistency. B) Inability to develop specialized applications for functional areas. C) Lack of flexibility in creating ad-hoc reports. D) Poor security. Show Answer Correct Answer: B) Inability to develop specialized applications for functional areas. 5. Which data model uses parent-child relationships? A) Hierarchical. B) Relational. C) Network. D) Object-oriented. Show Answer Correct Answer: A) Hierarchical. 6. Which of the following statements about queries is FALSE? A) Queries can filter data. B) Queries can be used to update records. C) Queries can display data in reports. D) Queries cannot be modified after they are created. Show Answer Correct Answer: D) Queries cannot be modified after they are created. 7. Entity-Relationship Model was developed by ..... in 1976. A) Chen. B) Codd. C) Dr. Edgar. D) None of these. Show Answer Correct Answer: A) Chen. 8. What is the purpose of normalisation in a relational database? A) To reduce data redundancy and ensure integrity. B) To increase data redundancy and complexity. C) To speed up searching for data. D) To store data in a non-structured manner. Show Answer Correct Answer: A) To reduce data redundancy and ensure integrity. 9. Define a foreign key and its purpose. A) A foreign key is a field that links two tables by referencing the primary key of another table, ensuring data integrity. B) A foreign key is a field that stores data without any relationship to other tables. C) A foreign key is a type of primary key used in the same table. D) A foreign key is a unique identifier for a single table. Show Answer Correct Answer: A) A foreign key is a field that links two tables by referencing the primary key of another table, ensuring data integrity. 10. What is the purpose of a report in a database? A) To enter data. B) To display data in a formatted way. C) To delete data. D) To create tables. Show Answer Correct Answer: B) To display data in a formatted way. 11. What problem in file systems occurs when data is scattered across multiple files in different formats? A) Data redundancy. B) Atomicity problems. C) Security problems. D) Data isolation. Show Answer Correct Answer: D) Data isolation. 12. What does the 'primary key' constraint ensure? A) Uniqueness of values in a column. B) Allows null values. C) Links to another table. D) Defines the data type. Show Answer Correct Answer: A) Uniqueness of values in a column. 13. Which SQL operation is used to retrieve data from a database? A) INSERT. B) DELETE. C) SELECT. D) MODIFY. Show Answer Correct Answer: C) SELECT. 14. Which relationship type represents a single record in one table linked to multiple records in another table? A) One-to-many. B) One-to-one. C) Many-to-many. D) Self-referencing. Show Answer Correct Answer: A) One-to-many. 15. What is the purpose of an Access Object in Microsoft Access? A) To store only images and videos. B) To automatically generate reports without user input. C) To create new databases from scratch. D) To provide a way to interact with and manage database elements. Show Answer Correct Answer: D) To provide a way to interact with and manage database elements. 16. To skip the first 5 documents in a query result, you use: A) .limit(5). B) .skip(5). C) .offset(5). D) .start(5). Show Answer Correct Answer: B) .skip(5). 17. If you want to store "Grades" in a student database, which field type is most suitable? A) Short Text. B) Number. C) Date/Time. D) Boolean (Yes/No). Show Answer Correct Answer: B) Number. 18. Choose the best example of enforcing referential integrity between Customer and Subscription. A) Delete all subscriptions before any customer insert. B) Prevent a subscription referencing a missing custID. C) Require subID to match productID in both tables. D) Allow duplicate custID values across all tables. Show Answer Correct Answer: B) Prevent a subscription referencing a missing custID. 19. ..... is a bottom-up approach in which two lower level entities combine to form a higher level entity A) Aggregation. B) Specialization. C) Generalization. D) None of the above. Show Answer Correct Answer: A) Aggregation. 20. What is the function of the Quick Access Toolbar in a database application? A) It organizes information into columns and rows. B) It provides a simplified interface for entering, modifying, and viewing database records. C) It displays a database's name. D) It provides access to commonly used functions. Show Answer Correct Answer: D) It provides access to commonly used functions. 21. ASSERTION:-If our database name is 'schooldb' and we want to drop this database, the query will work if we will write our database name in capital letters. REASON:-SQL is a not a case sensitive. A) Both A and R are true and R is the correct explanation for A. B) Both A and R are true and R is not the correct explanation for A. C) A is True but R is False. D) A is false but R is True. Show Answer Correct Answer: A) Both A and R are true and R is the correct explanation for A. 22. Which of the following statements about relations (tables) is FALSE? A) Each relation in a schema has a unique name. B) Each attribute within a relation has a unique name. C) The order of tuples (rows) is not significant. D) Duplicate rows are always allowed by definition. Show Answer Correct Answer: D) Duplicate rows are always allowed by definition. 23. When data is stored in the form of tables (rows and columns), it is part of which model? A) Hierarchical. B) Relational. C) Network. D) Object-oriented. Show Answer Correct Answer: B) Relational. 24. Which of the following SQL clauses is used to combine rows from two or more tables based on a related column? A) UNION. B) INTERSECT. C) JOIN. D) SELECT. Show Answer Correct Answer: C) JOIN. 25. Which clause filters rows after aggregation? A) WHERE. B) HAVING. C) FILTER. D) GROUP BY. Show Answer Correct Answer: B) HAVING. ← PreviousNext →Related QuizzesClass 11 Computer Science Chapter 7 Database Concepts Quiz 1Class 11 Computer Science Chapter 7 Database Concepts Quiz 2Class 11 Computer Science Chapter 7 Database Concepts Quiz 3Class 11 Computer Science Chapter 7 Database Concepts Quiz 4Class 11 Computer Science Chapter 7 Database Concepts Quiz 5Class 11 Computer Science Chapter 7 Database Concepts Quiz 6Class 11 Computer Science Chapter 7 Database Concepts Quiz 7Class 11 Computer Science Chapter 7 Database Concepts Quiz 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books