This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 65 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 65 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a dependency diagram used for? A) To manage user permissions in a system. B) To visualize relationships and dependencies between components in a system. C) To create a timeline of project milestones. D) To track the performance of individual components. Show Answer Correct Answer: B) To visualize relationships and dependencies between components in a system. 2. What is one role of a Security DBA? A) Scheduling software updates. B) Managing indexing and query logs. C) Implementing access control. D) None of the above. Show Answer Correct Answer: C) Implementing access control. 3. What does NoSQL stand for? A) Not Optimized SQL. B) Non-SQL Databases. C) Not Only SQL. D) Non-Structured Query Language. Show Answer Correct Answer: C) Not Only SQL. 4. Which SQL command is used to modify existing records in a table? A) INSERT. B) UPDATE. C) SELECT. D) DELETE. Show Answer Correct Answer: B) UPDATE. 5. What is one function of metadata? A) Helps identify where data came from. B) Helps store archived logs. C) Helps execute database queries. D) None of the above. Show Answer Correct Answer: A) Helps identify where data came from. 6. Describe the process of normalizing a database and why it is important in database design. A) It is important in order to minimize data redundancy, improve data integrity, and optimize database performance. B) It is only important for small databases, not large ones. C) It is not important, as it does not affect data integrity. D) It is important for increasing data redundancy and decreasing data integrity. Show Answer Correct Answer: A) It is important in order to minimize data redundancy, improve data integrity, and optimize database performance. 7. Anything that can have data stored about it, for example, a person, place, event, or thing. A) Entity. B) Object. C) Attribute. D) Record. Show Answer Correct Answer: A) Entity. 8. To ..... a database means to change existing information, such as updating an address. A) Update. B) Delete. C) Create. D) Retrieve. Show Answer Correct Answer: A) Update. 9. What are the types of NOSQL databases? A) Document databases. B) Key-value stores. C) Graph & Column-oriented databases. D) All of the above. Show Answer Correct Answer: D) All of the above. 10. What is the role of application programs in relation to a DBMS? A) They create the database structure. B) They manage the DBMS. C) They request data from the DBMS. D) They store data directly in the database. Show Answer Correct Answer: C) They request data from the DBMS. 11. Which of the folowing starts off with open, undo, and can be customized to contain the commands you use most frequently? A) A worksheet. B) The help window. C) The quick access toolbar. D) The ribbon. Show Answer Correct Answer: C) The quick access toolbar. 12. What is a key characteristic of a "One to One" relationship? A) Multiple items in each table. B) One item in one table, multiple in another. C) One item in each table. D) No items in either table. Show Answer Correct Answer: C) One item in each table. 13. How does a Data Mart differ from a Data Warehouse? A) A Data Mart is a subset of a Data Warehouse, focused on a specific business area. B) A Data Warehouse is a subset of a Data Mart, focused on a specific business area. C) A Data Mart and a Data Warehouse are the same. D) A Data Mart is used for transactional processing, while a Data Warehouse is used for analytical processing. Show Answer Correct Answer: A) A Data Mart is a subset of a Data Warehouse, focused on a specific business area. 14. What is the main goal of data verification? A) To check the format of data. B) To ensure data is logically consistent. C) To ensure data matches the original source. D) To prevent concurrent access. Show Answer Correct Answer: C) To ensure data matches the original source. 15. Electronic is an example of Digital database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 16. Which property guarantees isolation of transactions? A) Durability. B) Isolation. C) Consistency. D) Atomicity. Show Answer Correct Answer: B) Isolation. 17. In database normalisation, what is the second normal form (2NF)? A) A table that is in 1NF and has no partial dependencies. B) A table that is in 1NF and has no transitive dependencies. C) A table that is in 1NF and has a single primary key. D) A table that is in 1NF and has all foreign keys removed. Show Answer Correct Answer: A) A table that is in 1NF and has no partial dependencies. 18. ..... is a person, place, object, event or concept in the user environment about which company wishes to maintain the data A) Attribute. B) Entity. C) Relationship. D) None of these. Show Answer Correct Answer: B) Entity. 19. A column in a table in a database. A) Field. B) Record. C) Table. D) Row. Show Answer Correct Answer: A) Field. 20. Perintah ini digunakan untuk menampilkan basis data yang telah dibuat adalah ..... A) Databases;. B) Select databases;. C) Show database;. D) Show databases;. E) Show databases:. Show Answer Correct Answer: D) Show databases;. 21. In a school database, which of the following would be the MOST suitable primary key? A) First Name. B) Student ID Number. C) Grade. D) Date of Birth. Show Answer Correct Answer: B) Student ID Number. 22. Which of the following types of queries retrieves specific data from a database? A) Delete Query. B) Select Query. C) Append Query. D) Make Table Query. Show Answer Correct Answer: B) Select Query. 23. What is the function of an "index" in a relational database? A) To delete data from multiple tables. B) To create a relationship between two tables. C) To improve the speed of data retrieval. D) To perform full-text searches. Show Answer Correct Answer: C) To improve the speed of data retrieval. 24. In the context of relational databases, what is a composite key? A) A single attribute that uniquely identifies a record. B) A combination of two or more attributes that uniquely identify a record. C) An attribute that can accept null values. D) A foreign key that refers to a primary key in another table. Show Answer Correct Answer: B) A combination of two or more attributes that uniquely identify a record. 25. Alphanumeric A) A data type that consists only of letters. B) A data type that consists only of numbers. C) A data type that can consist of either letters or numbers or both. D) A data type that consists of special characters only. Show Answer Correct Answer: C) A data type that can consist of either letters or numbers or both. ← 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