This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 2 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 2 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is NOT a basic term in database concepts? A) Entity. B) Attributes. C) Relationships. D) Function. Show Answer Correct Answer: D) Function. 2. Microsoft Access's data dictionary displays all of the following information about a field except the ..... A) Size of the field. B) Format of the field. C) Description of the field. D) Ownership of the field. Show Answer Correct Answer: D) Ownership of the field. 3. A table is known as ..... A) Tuple. B) Attribute. C) Relation. D) Entity. Show Answer Correct Answer: C) Relation. 4. Why are databases important for businesses? A) They allow businesses to make smart choices and plan for the future. B) They help in organizing physical files. C) They provide a list of all installed software. D) They only work in the cloud. Show Answer Correct Answer: A) They allow businesses to make smart choices and plan for the future. 5. What is 'knowledge' in the context of data processing? A) Knowledge is the same as data. B) Knowledge is the insight gained from processing information. C) Knowledge is the raw facts without context. D) Knowledge is the physical storage of data. Show Answer Correct Answer: B) Knowledge is the insight gained from processing information. 6. What are the cardinality and modality constraints in an entity-relationship model? A) They refer to the location and weight of the entities. B) They refer to the color and size of the entities. C) They refer to the number of instances of one entity that can be associated with the number of instances of another entity and whether the relationship between entities is mandatory or optional. D) They refer to the age and gender of the entities. Show Answer Correct Answer: C) They refer to the number of instances of one entity that can be associated with the number of instances of another entity and whether the relationship between entities is mandatory or optional. 7. While entering gender in a field, Rahul selects data type as Yes/No and sets caption as "Female?" . What will this do? A) Allow only numeric input. B) Accept long text. C) Provide checkbox for Female option. D) Filter female names. Show Answer Correct Answer: C) Provide checkbox for Female option. 8. A unique identifier for a table. It is a special case of a candidate key. A) Primary key. B) Foreign key. C) Unique key. D) Composite key. Show Answer Correct Answer: A) Primary key. 9. What does 'durability' ensure in ACID properties? A) Data can be easily modified. B) Transactions are reversible. C) Data is always accurate. D) Completed transactions remain persistent. Show Answer Correct Answer: D) Completed transactions remain persistent. 10. ASSERTION:-Drop command is used to delete a database. REASON:-Drop is an example of DDL. 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: B) Both A and R are true and R is not the correct explanation for A. 11. Application form can be a paper-based or electronic. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 12. What is the purpose of the ORDER BY clause in SQL? A) To filter records based on a condition. B) To sort the result set in ascending or descending order. C) To group records that have the same values. D) To join two or more tables. Show Answer Correct Answer: B) To sort the result set in ascending or descending order. 13. What is a query in the context of databases? A) A request for data or information from a database. B) A type of database management system. C) A tool for designing database schemas. D) A method for updating database records. Show Answer Correct Answer: A) A request for data or information from a database. 14. Which of the following correctly defines a database record? A) A single piece of information in a database. B) A column in a table. C) A summary of data. D) A collection of related fields in a row. Show Answer Correct Answer: D) A collection of related fields in a row. 15. What is the main goal of data modeling? A) Definition of entities, attributes, relationships, and constraints. B) Optimizing the performance of an information system. C) Standardization of internal and external data communication protocols. D) None of the above. Show Answer Correct Answer: A) Definition of entities, attributes, relationships, and constraints. 16. Which of the following is a component of a database system? A) Hardware. B) Software. C) Data. D) All of the above. Show Answer Correct Answer: D) All of the above. 17. Which of the following activities is NOT part of the requirements gathering process for database design? A) Creating Entity-Relationship Diagrams (ERDs). B) Conducting interviews with key stakeholders. C) Analyzing existing data and systems. D) Implementing database security measures. Show Answer Correct Answer: D) Implementing database security measures. 18. Which problem occurs in file systems when the same data is stored in multiple places? A) Data isolation. B) Integrity problems. C) Data redundancy and inconsistency. D) Security problems. Show Answer Correct Answer: C) Data redundancy and inconsistency. 19. What is a "field" in a database? A) A collection of related records. B) A single piece of information within a record. C) A type of data structure. D) A secondary key. Show Answer Correct Answer: B) A single piece of information within a record. 20. What is the purpose of a database index? A) To improve the speed of data retrieval. B) To increase the size of the database. C) To make the database more complex. D) To store additional information about the database. Show Answer Correct Answer: A) To improve the speed of data retrieval. 21. What is the third normal form (3NF) in database normalisation? A) A table that is in 2NF and has no transitive dependencies. B) A table that is in 2NF and has a single primary key. C) A table that is in 2NF and has all foreign keys removed. D) A table that is in 2NF and has no partial dependencies. Show Answer Correct Answer: A) A table that is in 2NF and has no transitive dependencies. 22. What is the purpose of a database view? A) To provide a simplified view of the database. B) To improve the speed of data retrieval. C) To increase the size of the database. D) To make the database more complex. Show Answer Correct Answer: A) To provide a simplified view of the database. 23. What is a foreign key? A) A key that is used to encrypt data. B) A primary key from one table that appears in another table to link the two together. C) A key that is used to delete records. D) A key that is used to update records. Show Answer Correct Answer: B) A primary key from one table that appears in another table to link the two together. 24. How do you filter records in a SQL query? A) Using the WHERE clause. B) Using the SELECT clause. C) Using the FROM clause. D) Using the JOIN clause. Show Answer Correct Answer: A) Using the WHERE clause. 25. What is a primary source of metadata? A) Query templates. B) Printed reports and memos. C) Business rules and data models. D) None of the above. Show Answer Correct Answer: C) Business rules and data models. ← PreviousNext →Related QuizzesClass 11 Computer Science Chapter 7 Database Concepts Quiz 1Class 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 10Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books