This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 35 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 35 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is NOT a type of database recovery technique? A) Checkpoint. B) Rollback. C) Commit. D) Backup. Show Answer Correct Answer: C) Commit. 2. What does the SELECT clause do in SQL? A) It retrieves data from a database. B) It inserts data into a database. C) It updates data in a database. D) It deletes data from a database. Show Answer Correct Answer: A) It retrieves data from a database. 3. Which of the following is not a benefit of using a relational database A) Improves data integrity. B) Reduces the complexity of the database. C) Reduces inaccurate data being stored. D) Removes duplicate data being stored in tables. Show Answer Correct Answer: B) Reduces the complexity of the database. 4. Which of the following best describes the difference between database and DBMS? A) A DBMS is data itself. B) A database stores data, DBMS manages it. C) A database is a programming language. D) DBMS is used for internet access. Show Answer Correct Answer: B) A database stores data, DBMS manages it. 5. Which of the following is an example of a table in a database? A) A list of folders. B) A list of records. C) A list of images. D) A list of names. Show Answer Correct Answer: B) A list of records. 6. Which is fundamental to any computer system? A) Entity. B) Data. C) Attribute. D) Instance. Show Answer Correct Answer: B) Data. 7. Which of the following is an advantage of using a database, except ..... A) Cost of setup and maintenance. B) Increased data redundancy. C) Improved data accessibility. D) Enhanced data security. Show Answer Correct Answer: A) Cost of setup and maintenance. 8. Which command lists all databases in PostgreSQL? A) SHOW DATABASES;. B) \l. C) LIST DATABASES;. D) DISPLAY DATABASES;. Show Answer Correct Answer: B) \l. 9. Which of the following is NOT a main component of a database? A) Tables. B) Records. C) Fields. D) Pixels. Show Answer Correct Answer: D) Pixels. 10. According to the example table, which of the following is a record for Johnny Mitchell? A) 11170, Johnny, Mitchell, 1420 Jon, Tupelo, MS, 38804. B) 12983, Ann, Hale, 102 Hwy 45, Saltillo, MS, 38866. C) 23712, Joseph, Collins, 520 Court Dr., Tupelo, MS, 38801. D) 25890, Albert, Jones, 2 Lakeshore Ave., Verona, MS, 38879. Show Answer Correct Answer: A) 11170, Johnny, Mitchell, 1420 Jon, Tupelo, MS, 38804. 11. A field identified in a record as holding the unique identifier for a record is called the ..... A) Identifier key. B) Primary key. C) Primary field. D) Unique ID. Show Answer Correct Answer: B) Primary key. 12. What is the purpose of normalisation in a database? A) To increase data redundancy. B) To ensure data is stored in a single table. C) To reduce data redundancy and improve data integrity. D) To create more tables in the database. Show Answer Correct Answer: C) To reduce data redundancy and improve data integrity. 13. The attribute name could be structured as an attribute consisting of first name, middle name and last name. This type of attribute is called: A) Simple attribute. B) Composite attribute. C) Multi-valued attribute. D) Derived attribute. Show Answer Correct Answer: B) Composite attribute. 14. Which problem occurs when multiple users access the same file simultaneously without coordination? A) Integrity problems. B) Data redundancy. C) Concurrent access anomalies. D) Security problems. Show Answer Correct Answer: C) Concurrent access anomalies. 15. ..... are the languages used to write commands to access, insert, update and delete data stored. A) High level language. B) Low level language. C) Database access language. D) Operating system. Show Answer Correct Answer: C) Database access language. 16. What is the primary goal of database design? A) To create complex queries. B) To minimize data redundancy and ensure data integrity. C) To maximize data entry speed only. D) To replace programming. Show Answer Correct Answer: B) To minimize data redundancy and ensure data integrity. 17. Which of the following is NOT a valid MongoDB data type? A) String. B) Double. C) Timestamp. D) Pointer. Show Answer Correct Answer: D) Pointer. 18. When moving from a flat-file database to a relational database, what is the primary reason for the reduction in required external storage space? A) Data items, such as teacher names, are stored only once instead of being repeated. B) Relational databases compress all text into numeric codes. C) Student names are deleted to make room for relationship IDs. D) Relational tables do not use traditional rows or columns. Show Answer Correct Answer: A) Data items, such as teacher names, are stored only once instead of being repeated. 19. In a relational database, each tuple is divided into fields called A) Relations. B) Domains. C) Queries. D) None of the above. Show Answer Correct Answer: B) Domains. 20. What is the purpose of an input mask? A) To format data entry in a specific pattern. B) To delete records automatically. C) To prevent duplicate records. D) To create a backup of the database. Show Answer Correct Answer: A) To format data entry in a specific pattern. 21. In a relational database, what uniquely identifies a record? A) Column name. B) Primary key. C) Data type. D) File path. Show Answer Correct Answer: B) Primary key. 22. Which database type is most suitable for handling large-scale, flexible schema data? A) NoSQL. B) Relational. C) Network. D) Hierarchical. Show Answer Correct Answer: A) NoSQL. 23. Which of the following is an example of a typical DBMS functionality? A) Designing user interfaces. B) Creating a new programming language. C) Defining a particular database in terms of its data types. D) Developing hardware components. Show Answer Correct Answer: C) Defining a particular database in terms of its data types. 24. Which pane in MS Access displays the list of tables, forms, queries, and reports? A) Status Bar. B) Navigation Pane. C) Field Template Pane. D) Object Tabs. Show Answer Correct Answer: B) Navigation Pane. 25. Which of the following queries will correctly filter groups based on aggregate functions? A) SELECT department id, COUNT(*) FROM employees HAVING COUNT(*) > 5;. B) SELECT department id, COUNT(*) FROM employees WHERE COUNT(*) > 5;. C) SELECT department id, COUNT(*) FROM employees GROUP BY COUNT(*) > 5;. D) SELECT department id, COUNT(*) FROM employees WHERE department id HAVING COUNT(*) > 5;. Show Answer Correct Answer: A) SELECT department id, COUNT(*) FROM employees HAVING COUNT(*) > 5;. ← 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