This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 33 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 33 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Why are databases important? A) Data Duplication, Data Obfuscation, Data Inaccessibility, Data Inefficiency. B) Data Deletion, Data Corruption, Data Leakage, Data Mismanagement. C) Data Visualization, Data Encryption, Data Backup, Data Storage. D) Data Organization, Data Integrity, Data Security, Data Analysis. Show Answer Correct Answer: D) Data Organization, Data Integrity, Data Security, Data Analysis. 2. DML is provided for A) Description of the logical structure of the database. B) Addition of new structures n the database system. C) Manipulation & processing of database. D) Definition of physical structure of the database system. Show Answer Correct Answer: C) Manipulation & processing of database. 3. What is a table in the context of databases? A) A field that uniquely identifies a record. B) A set of facts or figures arranged in a column and row structure. C) A heading for organizing data. D) A person, place, or object represented in a relational database. Show Answer Correct Answer: B) A set of facts or figures arranged in a column and row structure. 4. What is the process of identifying and correcting errors in a program called? A) Compiling. B) Documenting. C) Debugging. D) Flowcharting. Show Answer Correct Answer: C) Debugging. 5. What is the purpose of a conditional filter in a database? A) To delete data. B) To display records that meet specific conditions. C) To create new fields. D) To format data. Show Answer Correct Answer: B) To display records that meet specific conditions. 6. What is the main focus of the conceptual level in a database? A) Internal data storage details. B) User interface designs. C) Community-wide data definition. D) Individual user view of the data. Show Answer Correct Answer: C) Community-wide data definition. 7. Why is understanding database concepts essential? A) For playing computer games. B) For social media usage. C) For watching movies online. D) For effective data management and decision-making. Show Answer Correct Answer: D) For effective data management and decision-making. 8. What is the purpose of a primary key in a database table? A) To uniquely identify each row in the table. B) To store additional information about the table. C) To categorize the data within the table. D) To establish relationships between tables. Show Answer Correct Answer: A) To uniquely identify each row in the table. 9. What is the primary focus of the database management system? A) To develop applications. B) To create user interfaces. C) To maintain and organize data. D) To manage hardware. Show Answer Correct Answer: C) To maintain and organize data. 10. For some relations, modifying data can have undesirable consequences called: A) Referential integrity constraint. B) Modification anomalies. C) Normalization form. D) Transitive dependencies. Show Answer Correct Answer: B) Modification anomalies. 11. What is the best way to enter large amounts of data into a database? A) Typing it in manually. B) Printing and scanning the information. C) Using a word processor. D) Importing it from other sources. Show Answer Correct Answer: D) Importing it from other sources. 12. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with: A) A particular column in a particular underlying table. B) A particular column in a particular row. C) A particular row in a particular underlying table. D) None of the above is correct. Show Answer Correct Answer: A) A particular column in a particular underlying table. 13. What is a schema in database design? A) A column of data in a table. B) The overall logical structure of a database. C) A security password. D) A user's record. Show Answer Correct Answer: B) The overall logical structure of a database. 14. Which MongoDB command is used to display all databases? A) Show collections. B) Db.getCollectionNames(). C) Show dbs. D) Db.showDatabases(). Show Answer Correct Answer: C) Show dbs. 15. Different relation classes created by techniques to prevent modification anomalies are called: A) Normalization forms. B) Referential integrity constraints. C) Functional dependencies. D) None of the above. Show Answer Correct Answer: A) Normalization forms. 16. Differentiate between a primary key and a candidate key. A) A primary key is optional, whereas a candidate key is mandatory. B) A primary key can be duplicated, while a candidate key cannot. C) A primary key is a unique identifier for a record, while a candidate key is any potential unique identifier. D) A primary key is a foreign key, while a candidate key is a local key. Show Answer Correct Answer: C) A primary key is a unique identifier for a record, while a candidate key is any potential unique identifier. 17. Which query returns all records where GDP is greater than 50, 000? A) SELECT * FROM world WHERE gdp > 50000;. B) SELECT gdp FROM world > 50000;. C) GET ALL world WHERE gdp > 50000;. D) SEARCH * world WHEN gdp > 50000;. Show Answer Correct Answer: A) SELECT * FROM world WHERE gdp > 50000;. 18. Which of the following operations requires the relations to be union compatible? A) UNION. B) INTERSECTION. C) DIFFERENCE. D) ALL OF THESE. Show Answer Correct Answer: D) ALL OF THESE. 19. Normalization helps make database management easier by: A) Increasing redundancy. B) Complicating updates. C) Simplifying data maintenance. D) Reducing data security. Show Answer Correct Answer: C) Simplifying data maintenance. 20. Which of the following is a DBMS for desktop computers? A) DB2. B) Oracle Database. C) Microsoft SQL Server. D) Microsoft Access. Show Answer Correct Answer: D) Microsoft Access. 21. Discuss the key features and benefits of using graph databases. A) Graph databases have no key features or benefits. B) Graph databases provide flexibility in data storage, support for hierarchical data structures, and seamless integration with object-oriented programming languages. C) Graph databases are less efficient than traditional relational databases. D) Graph databases are not suitable for complex data models. Show Answer Correct Answer: B) Graph databases provide flexibility in data storage, support for hierarchical data structures, and seamless integration with object-oriented programming languages. 22. Hubungan / relationship yang menggambarkan hubungan antara actor dengan usecase disebut ..... A) Association. B) Generalization. C) Dependency. D) Extend. E) Include. Show Answer Correct Answer: A) Association. 23. How is a composite entity identifier formed? A) Refers to the number of times an instance in one entity can be associated with instances in the related entity. B) Uses two or more entities to represent an interaction or association. C) The minimum number of attributes are combined to achieve this goal. D) By ensuring that the data does not get out of sync. Show Answer Correct Answer: C) The minimum number of attributes are combined to achieve this goal. 24. Multiple primary keys in a table A) True; a table can have multiple primary keys. B) False; a table can only have one primary key. C) A table can have primary keys in different columns. D) A table can have primary keys if it has foreign keys. Show Answer Correct Answer: B) False; a table can only have one primary key. 25. Which of the following is a function of a database? A) Data encryption. B) Efficient data storage. C) Data visualization. D) Data analysis. Show Answer Correct Answer: B) Efficient data storage. ← 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