This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 74 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 74 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the primary advantage of using a flat-file database over a relational database for small, simple tasks? A) Faster data retrieval for complex queries. B) More efficient handling of large volumes of data. C) Simplicity in design and ease of use. D) Better data integrity and securityTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: C) Simplicity in design and ease of use. 2. Which technique is used to control access to data in a multi-user environment? A) Data compression. B) Data encryption. C) Locking. D) Indexing. Show Answer Correct Answer: C) Locking. 3. Define DDL and name some commands. A) Data Definition Language, commands include CREATE, ALTER, DROP. B) Data Description Language, commands include SELECT, INSERT, UPDATE. C) Data Derivation Language, commands include GRANT, REVOKE, COMMIT. D) Data Distribution Language, commands include JOIN, UNION, INTERSECT. Show Answer Correct Answer: A) Data Definition Language, commands include CREATE, ALTER, DROP. 4. What is the purpose of the Isolation property in ACID? A) To ensure that the database is always available. B) To prevent concurrent transactions from interfering with each other. C) To make sure transactions are executed quickly. D) To encrypt the data during transactions. Show Answer Correct Answer: B) To prevent concurrent transactions from interfering with each other. 5. Explain the concept of a 'domain' in databases. A) A domain in databases is the set of allowable values for an attribute, defining its data type and constraints. B) A domain in databases is the process of indexing data for faster retrieval. C) A domain in databases is the overall structure of a database system. D) A domain in databases refers to the physical storage location of data. Show Answer Correct Answer: A) A domain in databases is the set of allowable values for an attribute, defining its data type and constraints. 6. Explain the concept of data redundancy in database management. A) Data redundancy has no impact on data integrity in database management. B) Data redundancy is the process of organizing data in a database to minimize redundancy and dependency. C) Data redundancy involves combining multiple tables into one to simplify the database structure. D) Data redundancy is the process of adding redundant data to a database to improve read performance for large tables. Show Answer Correct Answer: A) Data redundancy has no impact on data integrity in database management. 7. Fill in the blank: ..... command is used to remove primary key from a table in SQL. A) Update. B) Remove. C) Alter. D) Drop. Show Answer Correct Answer: D) Drop. 8. Which architecture is best suited for scalability? A) Centralized. B) Client/Server. C) File-based. D) Hierarchical. Show Answer Correct Answer: B) Client/Server. 9. Which of the following is NOT an example of a DBMS? A) MySQL. B) PostgreSQL. C) Microsoft Excel. D) Oracle Database. Show Answer Correct Answer: C) Microsoft Excel. 10. A value that is not available or not known is a A) Zero value. B) Unknown value. C) Missing value. D) NULL value. Show Answer Correct Answer: D) NULL value. 11. A ..... is a software management system designed to maintain a database. A) Information. B) File. C) Database. D) DBMS. Show Answer Correct Answer: D) DBMS. 12. Which DBMS architecture offers better fault tolerance? A) Centralized. B) Distributed. C) Hierarchical. D) File system. Show Answer Correct Answer: B) Distributed. 13. Why is backup and recovery crucial for database management? A) Backup and recovery are unnecessary for database management. B) Backup and recovery slow down database performance. C) Backup and recovery increase the risk of data corruption. D) Backup and recovery help maintain data integrity, minimize data loss, and enable restoration to a previous state. Show Answer Correct Answer: D) Backup and recovery help maintain data integrity, minimize data loss, and enable restoration to a previous state. 14. A composite key is usually: A) A sequential system-generated number. B) A single-column key. C) Made of multiple attributes that have real-world meaning. D) Automatically generated by Oracle. Show Answer Correct Answer: C) Made of multiple attributes that have real-world meaning. 15. A reason for using an SQL view to hide columns is: A) To simplify a result only. B) To prevent the display of sensitive data only. C) To accomplish both of the above. D) None of the above are reasons for using an SQL view. Show Answer Correct Answer: C) To accomplish both of the above. 16. In a student database, which of the following could be a field? A) Student ID. B) All students. C) Classroom. D) School. Show Answer Correct Answer: A) Student ID. 17. A logical schema, A) Is a model usually a diagram with data structures expressed which are independent of DBMS. B) Is a standard way of organizing information into accessible parts. C) Describes how data is actually stored on disk. D) Both (A) and (C). Show Answer Correct Answer: A) Is a model usually a diagram with data structures expressed which are independent of DBMS. 18. Why is data abstraction important in DBMS? A) It reduces server load. B) It hides complexity and ensures security. C) It increases redundancy. D) It helps design spreadsheets. Show Answer Correct Answer: B) It hides complexity and ensures security. 19. .... is the most prevalent database model. A) Hierarchical. B) Network. C) Relational. D) Object. Show Answer Correct Answer: C) Relational. 20. In a relational database, two files can be joined if they have what in common? A) The same index. B) The same type of data. C) A common field. D) The same number of records. Show Answer Correct Answer: C) A common field. 21. Perintah DML yang digunakan untuk menambahkan data baru ke tabel adalah ..... A) ALTER. B) Delete. C) Insert. D) Update. E) Select. Show Answer Correct Answer: C) Insert. 22. Which of these is an example of alphanumeric data? A) 67890. B) HelloWorld. C) A12345. D) %%%%. Show Answer Correct Answer: C) A12345. 23. What is a potential consequence of poor concurrency control in a database? A) Faster query execution. B) Improved data integrity. C) Lost updates or inconsistent data. D) Enhanced system performance. Show Answer Correct Answer: C) Lost updates or inconsistent data. 24. What is a query? A) A method to store data. B) A way to delete data. C) A request to retrieve data. D) A type of database. Show Answer Correct Answer: C) A request to retrieve data. 25. Which operation could violate referential integrity in this database? A) Updating a product price value field. B) Deleting a customer still referenced by subscriptions. C) Changing a customer's email address field. D) Renaming a productName for marketing. Show Answer Correct Answer: B) Deleting a customer still referenced by subscriptions. ← 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