This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 76 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 76 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In a database, a ..... represents a single category of information within a table, like "Name" or "Age." A) Field. B) Record. C) Table. D) Database. Show Answer Correct Answer: A) Field. 2. DBMS means ..... A) DataBase Maintain System. B) Data Bit Management System. C) Database Management System. D) DataBase Management Software. Show Answer Correct Answer: C) Database Management System. 3. Which of the following is a prerequisite for creating a distributed database? A) SQL Server must be uninstalled. B) SQL Server must be installed as Express. C) The Agent must be set to Manual. D) The Agent must be Automatic. Show Answer Correct Answer: D) The Agent must be Automatic. 4. A ..... is an organized pool of logically related data. A) Wisdom. B) Database. C) Information system. D) Data. Show Answer Correct Answer: B) Database. 5. What type of relationship exists when one record in a table can be associated with multiple records in another table? A) One-to-One. B) None of the above. C) One-to-Many. D) Many-to-Many. Show Answer Correct Answer: C) One-to-Many. 6. What is the role of end users? A) To design the database. B) To write the software. C) To manage the DBMS. D) To access the database. Show Answer Correct Answer: D) To access the database. 7. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). One use of a database in a school is: A) To store and manage student grades. B) To play music for events. C) To send text messages. D) To design posters. Show Answer Correct Answer: A) To store and manage student grades. 8. A database ..... describes a database entity. A) Byte. B) Field. C) Record. D) Value. Show Answer Correct Answer: C) Record. 9. What is the primary purpose of data independence? A) To allow changes at one level without affecting others. B) To ensure data is always accurate. C) To simplify data retrieval. D) To increase data redundancy. Show Answer Correct Answer: A) To allow changes at one level without affecting others. 10. Which of the following removes the duplicate rows in database? A. B. C. D. A) SELECT. B) PROJECT. C) PRODUCT. D) INTERSECTION. Show Answer Correct Answer: B) PROJECT. 11. How do you modify a database schema? A) You modify a database schema by deleting all existing tables. B) You can only modify a database schema through a graphical user interface. C) You modify a database schema by creating and executing migration scripts. D) You modify a database schema by copying the entire database to a new server. Show Answer Correct Answer: C) You modify a database schema by creating and executing migration scripts. 12. What distinguishes a network database structure? A) Uses a linear data format. B) Allows many-to-many relationships using graph structure. C) Stores data only in tables. D) Uses no indexing. Show Answer Correct Answer: B) Allows many-to-many relationships using graph structure. 13. Which query selects all documents where age is greater than 25? A) \{age:> 25\}. B) \{age:\{$ gt:25\}\}. C) \{age:\{gt:25\}\}. D) \{age:=> 25\}. Show Answer Correct Answer: B) \{age:\{$ gt:25\}\}. 14. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity? A) Supertype entity. B) Subtype entity. C) Archetype entity. D) Instance entity. Show Answer Correct Answer: A) Supertype entity. 15. Which property ensures committed transactions survive system failures? A) Atomicity. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: D) Durability. 16. Which method brings data into the database from an existing file? A) Export. B) Input. C) Output. D) Import. Show Answer Correct Answer: D) Import. 17. Komponen berikut adalah bagian dari sistem basis data, kecuali ..... A) Perangkat keras. B) Perangkat Lunak. C) Brainware (pengguna). D) Ransomware. E) Sistem Informasi. Show Answer Correct Answer: D) Ransomware. 18. What distinguishes a centralized database from a distributed database? A) Centralized databases are faster. B) Centralized databases are located in one location. C) Distributed databases are easier to manage. D) Centralized databases require more servers. Show Answer Correct Answer: B) Centralized databases are located in one location. 19. DELETE A) An SQL command used to remove data. B) A command to add new data. C) A command to update existing data. D) A command to retrieve data. Show Answer Correct Answer: A) An SQL command used to remove data. 20. Explain what an entity is in a database. A) An entity refers to a database user. B) An entity is a distinct object or concept in a database, defined by its attributes. C) An entity is a method for data retrieval. D) An entity is a type of database query. Show Answer Correct Answer: B) An entity is a distinct object or concept in a database, defined by its attributes. 21. What is the function of an index in a database? A) To store large amounts of data. B) To speed up data retrieval. C) To increase data redundancy. D) To enforce data integrity. Show Answer Correct Answer: B) To speed up data retrieval. 22. Which type of entity represents an actual occurrence of an associated generalized entity? A) Supertype entity. B) Subtype entity. C) Archetype entity. D) Instance entity. Show Answer Correct Answer: D) Instance entity. 23. What does a record in a database table represent? A) A single piece of information. B) A single row of data. C) A collection of tables. D) A column of attributes. Show Answer Correct Answer: B) A single row of data. 24. Administration A) Managing database performance, users, backups, and maintenance. B) Creating user interfaces for applications. C) Designing network infrastructure. D) Developing software applications. Show Answer Correct Answer: A) Managing database performance, users, backups, and maintenance. 25. Which of the following is an example of a primary key in a student database? A) Student Name. B) Student ID. C) Student Age. D) Student Grade. Show Answer Correct Answer: B) Student 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