This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 16 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 16 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How does information differ from data? A) Information is raw, while data is processed. B) Data is meaningful, while information is not. C) Information is data that has been processed and given context. D) There is no difference between data and information. Show Answer Correct Answer: C) Information is data that has been processed and given context. 2. Which feature in reports allows grouping and summarizing data? A) Sorting. B) Grouping. C) Filtering. D) Formatting. Show Answer Correct Answer: B) Grouping. 3. Relationship A) A connection between tables in a database. B) A type of data structure used in programming. C) A method for sorting data in a database. D) A way to encrypt data for security. Show Answer Correct Answer: A) A connection between tables in a database. 4. Which of the following is NOT a characteristic of a database system? A) Multiple Views. B) Self-Describing Nature. C) Data Redundancy. D) Data Integrity. Show Answer Correct Answer: C) Data Redundancy. 5. Which statement about schema evolution is true? A) Schema cannot be changed after creation. B) Schema changes affect data structure. C) Data remains unchanged during schema evolution. D) Schema evolution is not supported in DBMS. Show Answer Correct Answer: B) Schema changes affect data structure. 6. What is normalization in database design? A) A way to combine multiple databases into one. B) A method to increase data redundancy in databases. C) A technique for encrypting database information. D) Normalization in database design is the process of structuring a database to minimize redundancy and dependency by organizing fields and tables. Show Answer Correct Answer: D) Normalization in database design is the process of structuring a database to minimize redundancy and dependency by organizing fields and tables. 7. What is the first step in an ETL process? A) Extraction. B) Transformation. C) Loading. D) Validation. Show Answer Correct Answer: A) Extraction. 8. Which SQL statement is used to update data in a database? A) SAVE. B) SAVE AS. C) UPDATE. D) MODIFY. Show Answer Correct Answer: C) UPDATE. 9. What is the disadvantage of using a DBMS? A) Data sharing. B) Data complexity. C) Data performance. D) Data security. Show Answer Correct Answer: B) Data complexity. 10. To change the structure of a table, you use: A) MODIFY TABLE. B) ALTER TABLE. C) UPDATE TABLE. D) CHANGE TABLE. Show Answer Correct Answer: B) ALTER TABLE. 11. Which structure is most commonly used in modern systems for storing and querying data? A) Network structure. B) Relational structure. C) Tree-based structure. D) Sequential file structure. Show Answer Correct Answer: B) Relational structure. 12. What are some common database security practices? A) Access controls, encryption, regular updates, security audits, monitoring and logging. B) Physical security, software installation, data archiving. C) Backup strategies, network segmentation, password sharing. D) Data replication, user training, firewall configuration. Show Answer Correct Answer: A) Access controls, encryption, regular updates, security audits, monitoring and logging. 13. Bagaimana cara membuat database baru dalam SQL? A) ADD DATABASE nama database;. B) INSERT INTO nama database;. C) UPDATE DATABASE nama database;. D) CREATE DATABASE nama database;. Show Answer Correct Answer: D) CREATE DATABASE nama database;. 14. A ..... is a collection of organized data that can be easily accessed, managed, and updated. A) Database. B) Spreadsheet. C) Document. D) Presentation. Show Answer Correct Answer: A) Database. 15. An ER diagram that shows the concepts of Specialization & Generalization are known as: A) Extended E-R diagram. B) Effective E-R diagram. C) Expanded E-R diagram. D) Enhanced E-R diagram. Show Answer Correct Answer: D) Enhanced E-R diagram. 16. What is the role of APIs in databases? A) To delete data. B) To create new databases. C) To allow different software systems to communicate. D) To secure data. Show Answer Correct Answer: C) To allow different software systems to communicate. 17. The value 'Computer Science' in the above example belongs to which concept? A) Entity. B) Domain. C) Schema. D) Tuple. Show Answer Correct Answer: B) Domain. 18. Which of the following is NOT a type of database management system (DBMS)? A) Hierarchical DBMS. B) Network DBMS. C) Relational DBMS. D) Object-Oriented DBMS. Show Answer Correct Answer: D) Object-Oriented DBMS. 19. How do data dictionaries help ensure data integrity and consistency? A) By deleting old data. B) By defining data types, constraints, and relationships. C) By storing data in multiple locations. D) By encrypting data. Show Answer Correct Answer: B) By defining data types, constraints, and relationships. 20. What does durability mean in the context of transactions? A) Changes must be verified. B) Changes are permanent even after a failure. C) Changes are temporary. D) Changes can be rolled back. Show Answer Correct Answer: B) Changes are permanent even after a failure. 21. What is the purpose of the 'where' clause in an SQL query? A) To specify conditions for filtering results. B) To define the structure of a table. C) To join multiple tables. D) To select all attributes. Show Answer Correct Answer: A) To specify conditions for filtering results. 22. When using the SQL INSERT statement: A) Rows can be modified according to criteria only. B) Rows cannot be copied in mass from one table to another only. C) Rows can be inserted into a table only one at a time. D) Rows can either be inserted into a table one at a time or in groups. Show Answer Correct Answer: D) Rows can either be inserted into a table one at a time or in groups. 23. What is a feature of reports in Access? A) They are static. B) They are dynamic. C) They are encrypted. D) They are temporary. Show Answer Correct Answer: B) They are dynamic. 24. Advantage of 3NF? A) It eliminates redundant data which in turn saves space and reduces manipulation anomalies. B) It gives the data status. C) It allows the tables to be queried in SQL. D) It prevents any new updates. Show Answer Correct Answer: A) It eliminates redundant data which in turn saves space and reduces manipulation anomalies. 25. Apa perbedaan antara tipe data CHAR dan VARCHAR dalam database? A) CHAR can store unlimited characters, while VARCHAR has a character limit. B) CHAR is fixed-length, while VARCHAR is variable-length. C) CHAR stores only numbers, while VARCHAR stores only letters. D) CHAR is case-sensitive, while VARCHAR is case-insensitive. Show Answer Correct Answer: B) CHAR is fixed-length, while VARCHAR is variable-length. ← 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