This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 67 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 67 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of metadata in a database? A) To store user data. B) To define data structures. C) To replicate data. D) To process queries. Show Answer Correct Answer: B) To define data structures. 2. What is the primary disadvantage of a flat file database? A) It is not user-friendly. B) It requires multiple tables. C) It can lead to data redundancy. D) It is too complex to implement. Show Answer Correct Answer: C) It can lead to data redundancy. 3. How can you export a report from Access to another format? A) Use the 'File' menu to print the report directly. B) Right-click the report and choose 'Delete' to remove it. C) Select 'Save As' to create a copy of the report. D) Use the 'External Data' tab to export the report to a different format. Show Answer Correct Answer: D) Use the 'External Data' tab to export the report to a different format. 4. What is normalization and why is it important? A) Normalization is a process that only affects data storage, not performance. B) Normalization is important because it minimizes data redundancy, ensures data integrity, and enhances query performance. C) Normalization is only necessary for small databases. D) Normalization increases data redundancy and slows down queries. Show Answer Correct Answer: B) Normalization is important because it minimizes data redundancy, ensures data integrity, and enhances query performance. 5. How can you filter data in a report in Access? A) You can filter data by exporting the report to Excel. B) Filtering is only possible in the query view, not in reports. C) You can only filter data by using SQL commands in Access. D) You can filter data in a report in Access by using the Filter By Form feature or applying filters in the report view. Show Answer Correct Answer: D) You can filter data in a report in Access by using the Filter By Form feature or applying filters in the report view. 6. What are the different types of Access Objects? A) Tables, Charts, Forms, Reports. B) Queries, Forms, Dashboards, Reports. C) Tables, Forms, Scripts, Views. D) Tables, Queries, Forms, Reports, Macros, Modules. Show Answer Correct Answer: D) Tables, Queries, Forms, Reports, Macros, Modules. 7. Explain the purpose of the 'GROUP BY' clause in SQL and provide an example. A) The 'GROUP BY' clause in SQL is used to sort the data in ascending order. B) The 'GROUP BY' clause in SQL is used to filter the data based on a condition. C) The 'GROUP BY' clause in SQL is used to update the data in a table. D) The purpose of the 'GROUP BY' clause in SQL is to group rows that have the same values and it is often used with aggregate functions. Show Answer Correct Answer: D) The purpose of the 'GROUP BY' clause in SQL is to group rows that have the same values and it is often used with aggregate functions. 8. Which type of database is best for handling large amounts of structured data? A) Flat-file database. B) Hierarchical database. C) Relational database. D) Network database. Show Answer Correct Answer: C) Relational database. 9. True or False:StudentName in the Students table is a domain. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 10. The ..... operation is used for selecting a subset with tuples according to a given condition. A) UNION. B) SELECT. C) INTERSECTION. D) DIFFERENCE. Show Answer Correct Answer: B) SELECT. 11. What is the function of the following command?Delete from r where P; A) Clears entries from relation. B) Deletes relation. C) Deletes particular tuple from relation. D) All of the mentioned. Show Answer Correct Answer: C) Deletes particular tuple from relation. 12. Which section of a PL/SQL anonymous block is *mandatory*? A) DECLARE. B) EXCEPTION. C) BEGIN (Executable Section). D) None are mandatory. Show Answer Correct Answer: C) BEGIN (Executable Section). 13. A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions? A) Data integrity management. B) Data storage management. C) Data reports. D) Security management. Show Answer Correct Answer: C) Data reports. 14. What does the term "key field" refer to in a database? A) A field that uniquely identifies a record within a table. B) Any field that is mandatory for data entry. C) The field with the most data in a database. D) A field that is hidden from the user for security reasonsTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: A) A field that uniquely identifies a record within a table. 15. The purpose of a database is to: A) Store and manage data efficiently. B) Replace spreadsheets. C) Store only text-based information. D) Eliminate the need for computers. Show Answer Correct Answer: A) Store and manage data efficiently. 16. Which of these would be the best choice for creating a music database in Excel? A) Artist's favorite food. B) Album title, release date, chart position, albums sold. C) Student name and ID. D) Teacher and their classes. Show Answer Correct Answer: B) Album title, release date, chart position, albums sold. 17. The statement in SQL which allows to change the definition of a table is A) Alter. B) Update. C) Create. D) Select. Show Answer Correct Answer: A) Alter. 18. What is a Composite Key in database management? A) A primary key that is derived from a unique key. B) A primary key for a table consisting of two or more fields. C) A foreign key that combines multiple tables. D) A unique key that is used to speed up queries. Show Answer Correct Answer: B) A primary key for a table consisting of two or more fields. 19. What is the default sort order of the ORDER BY clause? A) Ascending. B) Descending. C) Random. D) None. Show Answer Correct Answer: A) Ascending. 20. Which transaction property ensures database correctness? A) Durability. B) Consistency. C) Atomicity. D) Isolation. Show Answer Correct Answer: B) Consistency. 21. Which of the following is NOT a disadvantage of using a DBMS? A) Complexity. B) Cost. C) Performance. D) Data integrity. Show Answer Correct Answer: D) Data integrity. 22. Dr.E.F. Codd represented ..... rules that a database must obey if it has to be considered truly relational. A) 10. B) 15. C) 14. D) 12. Show Answer Correct Answer: C) 14. 23. A table contains: A) Only text data. B) Only numerical data. C) Rows and columns. D) Only primary keys. Show Answer Correct Answer: C) Rows and columns. 24. What happens when a relationship is enforced with referential integrity? A) Data in related tables remains consistent. B) Records are automatically deleted. C) The database sorts data automatically. D) The tables become locked. Show Answer Correct Answer: A) Data in related tables remains consistent. 25. Aaronique, Andre and Jahmar are organizing a student database. They have attributes ID, CITY, and NAME. Which one of these can be considered as a primary key? A) NAME. B) ID. C) CITY. D) ID, NAME. Show Answer Correct Answer: B) 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