This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 11 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the primary purpose of Design View in MS Access? A) To enter data quickly into tables. B) To modify the structure and properties of database objects. C) To create reports automatically. D) To run complex queries. Show Answer Correct Answer: B) To modify the structure and properties of database objects. 2. Section A:True or False (5 marks)-Write True or False beside each statement. A table is made up of rows and columns. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 3. What is a filter in a database? A) A tool to delete data. B) A tool to display only specific records based on criteria. C) A tool to create new tables. D) A tool to format data. Show Answer Correct Answer: B) A tool to display only specific records based on criteria. 4. What is the purpose of a "primary key" ? A) To link two tables together. B) To uniquely identify each record in a table. C) To create a relationship between two databases. D) To provide backup for a table's data. Show Answer Correct Answer: B) To uniquely identify each record in a table. 5. A company's employee table lists "Department = HR, IT, Sales." If one record shows "Department = XY, " this violates: A) Normalization. B) Domain Rule. C) Data Integrity. D) Redundancy Rule. Show Answer Correct Answer: C) Data Integrity. 6. What is the main function of the internal level? A) Shows user interface. B) Provides business rules. C) Defines physical storage. D) Represents reports. Show Answer Correct Answer: C) Defines physical storage. 7. An individual data item stored for an entity, for example, name, address, or date of birth. A) Attribute (database). B) Entity. C) Record. D) Field. Show Answer Correct Answer: A) Attribute (database). 8. What is the purpose of a relational database? A) To store data in tables with rows and columns. B) To create visual presentations. C) To manage email communications. D) To design web pages. Show Answer Correct Answer: A) To store data in tables with rows and columns. 9. What is the main purpose of a database catalog? A) To store user data. B) To manage user access. C) To describe the database structure and constraints. D) To create backups of the database. Show Answer Correct Answer: C) To describe the database structure and constraints. 10. Which of the following is used for entering, modifying, and viewing records in a database? A) Report. B) Form. C) Query. D) Table. Show Answer Correct Answer: B) Form. 11. What are the components of an E-R model? A) Entity. B) Attributes. C) Relationship. D) All the above. Show Answer Correct Answer: D) All the above. 12. The data values for all the fields related to a person or object is called a record. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: B) True. 13. If a shop keeps a table for all products, this table is called a: A) Schema. B) Relation. C) Entity. D) Domain. Show Answer Correct Answer: B) Relation. 14. What is the main advantage of using a database over a simple list? A) Databases are more difficult to use. B) Databases organize and retrieve data efficiently. C) Databases do not allow relationships between data. D) Databases only work on large computers. Show Answer Correct Answer: B) Databases organize and retrieve data efficiently. 15. What is the primary key for the continents table? A) Population. B) Continent. C) Name. D) Area. Show Answer Correct Answer: B) Continent. 16. Indicate whether the statement is true or false:Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 17. What does ACID stand for in the context of database transactions? A) Atomicity, Consistency, Isolation, Durability. B) Aggregate, Commit, Isolate, Distribute. C) Association, Constraint, Index, Data. D) All Columns In Database. Show Answer Correct Answer: A) Atomicity, Consistency, Isolation, Durability. 18. The purposes of normalization are: A) To ensure that the anomalies doesn't occur. B) To reduce data or storage redundancy. C) To ensure easy for record searching/finding. D) All the above. Show Answer Correct Answer: D) All the above. 19. A ..... is an organized collection of structured data. A) Information. B) File. C) Database. D) DBMS. Show Answer Correct Answer: C) Database. 20. What is the purpose of a foreign key in a database? A) To create a primary key for a table. B) To establish a relationship between two tables. C) To uniquely identify each row in a table. D) To store additional information about a table. Show Answer Correct Answer: B) To establish a relationship between two tables. 21. The DBMS can be divided into ..... major components. A) 4. B) 5. C) 6. D) 7. Show Answer Correct Answer: B) 5. 22. A data ..... is a set of rules that define valid data. A) Constraint. B) Data dictionary. C) Query. D) All of these. Show Answer Correct Answer: A) Constraint. 23. When should a composite unique identifier be used in a database design? A) When there is a one-to-one (1:1) relationship between two entities. B) When an entity has a many-to-many (N:N) relationship with another entity. C) When there are multiple attributes that together uniquely identify an entity. D) When a foreign key is used to link two entities together. Show Answer Correct Answer: C) When there are multiple attributes that together uniquely identify an entity. 24. Which of the following is a problem commonly associated with the old file-based approach? A) Centralized control of data. B) High data independence. C) Program-data dependence. D) Standardized query language. Show Answer Correct Answer: C) Program-data dependence. 25. How do records relate to rows in a database? A) Records are unrelated to rows in a database. B) Rows are a type of record that only contains metadata. C) Records are represented as rows in a database table. D) Records are stored in columns of a database table. Show Answer Correct Answer: C) Records are represented as rows in a database table. ← 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