This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 64 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 64 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Provide an example of a dependency in a database. A) EmployeeID $\rightarrow$ EmployeeName. B) EmployeeName $\rightarrow$ EmployeeID. C) ProjectID $\rightarrow$ EmployeeRole. D) DepartmentID $\rightarrow$ ProjectName. Show Answer Correct Answer: A) EmployeeID $\rightarrow$ EmployeeName. 2. What are relationships in the context of a relational database? A) Links between users and databases. B) The joins between tables in a relational database. C) The connections between different databases. D) The formatting styles in database tables. Show Answer Correct Answer: B) The joins between tables in a relational database. 3. What is the purpose of the TRY-CATCH statement in T-SQL? A) To declare variables. B) To handle exceptions. C) To define functions. D) To create loops. Show Answer Correct Answer: B) To handle exceptions. 4. A situation in which one table in a database has a foreign key that refers to a primary key in another table. A) Association. B) Relationship. C) Connection. D) Linkage. Show Answer Correct Answer: B) Relationship. 5. In MS Access, what is a record? A) A single column in a table. B) The table design blueprint. C) A complete set of related data about one item. D) The navigation pane. Show Answer Correct Answer: C) A complete set of related data about one item. 6. Peter Chen developed and defined a model of important relationships called the er model A) 1975. B) 1970. C) 1977. D) 1976. E) 1974. Show Answer Correct Answer: D) 1976. 7. Which of the following is an example of a row in a database? A) A single image. B) A single record. C) A single folder. D) A single name. Show Answer Correct Answer: B) A single record. 8. Which of the following is an example of a relationship? A) Marriage. B) Rainbow. C) Cooking. D) Friendship. Show Answer Correct Answer: A) Marriage. 9. What are the potential drawbacks of using stored procedures? A) Stored procedures are easier to maintain than application code. B) Stored procedures eliminate the need for database security. C) Potential drawbacks of using stored procedures include increased complexity, performance issues, reduced flexibility, and potential for vendor lock-in. D) Stored procedures always improve performance. Show Answer Correct Answer: C) Potential drawbacks of using stored procedures include increased complexity, performance issues, reduced flexibility, and potential for vendor lock-in. 10. Which key uniquely identifies a record in a table? A) Index key. B) Primary key. C) Secondary key. D) Foreign key. Show Answer Correct Answer: B) Primary key. 11. In a relational database, the three basic operations used to develop useful sets of data are ..... A) Select, project, and where. B) Select, join, and where. C) Select, project, and join. D) Where, from, and join. Show Answer Correct Answer: C) Select, project, and join. 12. This key uniquely identifies each record in an entity. A) Primary Key or Key Identifier. B) Foreign Key. C) Secondary Key. D) Composite Key. Show Answer Correct Answer: A) Primary Key or Key Identifier. 13. What can queries help you calculate in a database? A) Sums, averages, and counts. B) Movie durations. C) Song lengths. D) Art dimensions. Show Answer Correct Answer: A) Sums, averages, and counts. 14. Which SQL clause filters groups? A) HAVING. B) WHERE. C) ORDER BY. D) DISTINCT. Show Answer Correct Answer: A) HAVING. 15. Which SQL command would you use to change a student's course from "ICT Level 5" to "Software Engineering" ? A) SELECT. B) UPDATE. C) INSERT. D) DELETE. Show Answer Correct Answer: B) UPDATE. 16. In an ERD, what symbol represents an entity? A) Circle. B) Square. C) Diamond. D) Oval. Show Answer Correct Answer: B) Square. 17. What does the ORDER BY clause do? A) Filters results based on a condition. B) Sorts returned data by a chosen field. C) Deletes unwanted records. D) Inserts new records alphabetically. Show Answer Correct Answer: B) Sorts returned data by a chosen field. 18. What happens if a primary key is duplicated? A) The duplicate entry is stored without any issues. B) The database automatically corrects the duplicate entry. C) The database merges the duplicate entries into one. D) The database will reject the duplicate entry, resulting in an error. Show Answer Correct Answer: D) The database will reject the duplicate entry, resulting in an error. 19. Microsoft Access cannot create a 'many-to-many' relationship directly because it is a theoretical type. How must a developer implement this practically? A) By merging all data into one giant flat-file table. B) By using a primary key that contains blank records. C) By using a link table combined with two one-to-many relationships. D) By changing all related data types to Boolean logic. Show Answer Correct Answer: C) By using a link table combined with two one-to-many relationships. 20. A ..... helps speed up the retrieval of data by creating a quick lookup reference. A) Index. B) Table. C) View. D) Trigger. Show Answer Correct Answer: A) Index. 21. Why is it important for each record to have a unique primary key? A) To ensure data integrity. B) To make it colorful. C) To reduce file size. D) To increase speed. Show Answer Correct Answer: A) To ensure data integrity. 22. Which of the following is a characteristic of a relational database? A) Data is organized in tables. B) Data is stored in a flat file. C) Data cannot be queried. D) Data is stored in a hierarchical structure. Show Answer Correct Answer: A) Data is organized in tables. 23. What does the term 'cardinality' refer to in database relationships? A) The size of the database. B) The number of instances of one entity that can be associated with another. C) The type of data stored in a table. D) The speed of data retrieval. Show Answer Correct Answer: B) The number of instances of one entity that can be associated with another. 24. What is the maximum number of tables that can be related in MS Access? A) 5 tables. B) 10 tables. C) There is no practical limit. D) 20 tables. Show Answer Correct Answer: C) There is no practical limit. 25. In a 'one-to-many' relationship between a 'Customers' table and an 'Orders' table, where would you expect to find the linking field? A) A primary key unique only to the 'Orders' table. B) A foreign key in the 'Orders' table that matches the 'Customer ID'. C) An attachment field for customer photos in the 'Orders' table. D) A Boolean field in the 'Customers' table indicating if they have orders. Show Answer Correct Answer: B) A foreign key in the 'Orders' table that matches the 'Customer ID'. ← 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