This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 51 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 51 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. When might a DBMS be unnecessary? A) When data needs to be shared. B) When multiple users need access. C) When there are stringent real-time requirements. D) When the database is complex. Show Answer Correct Answer: C) When there are stringent real-time requirements. 2. What does DBMS provide for unauthorized access prevention? A) Only password protection. B) File encryption only. C) User authentication, authorization, and privilege management. D) Hardware locks. Show Answer Correct Answer: C) User authentication, authorization, and privilege management. 3. Identify the total number of attributes in a relational data model. A) Tuple. B) Entity. C) Degree. D) Cardinality. Show Answer Correct Answer: C) Degree. 4. What is the role of a data model in database design? A) A data model focuses solely on data retrieval methods. B) A data model provides a visual representation of data structures and relationships. C) A data model is only concerned with data storage techniques. D) A data model is used to create user interfaces for applications. Show Answer Correct Answer: B) A data model provides a visual representation of data structures and relationships. 5. Which term best describes the process of defining the structure of a database? A) Indexing. B) Normalization. C) Data Modeling. D) Querying. Show Answer Correct Answer: C) Data Modeling. 6. The ..... method defines a relation that contains a vertical subset of Relation. A) SELECT. B) UNION. C) PROJECT. D) SET DIFFERENCE. Show Answer Correct Answer: C) PROJECT. 7. True or False:An entity does not represent an object in the real world? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 8. You are designing entity descriptions for Customer(custID, title, firstname, surname, email) and Product(productID, title, subject, level, price). Which choice follows a correct procedure when no natural unique attribute exists? A) Introduce a new unique identifier as the primary key. B) Use the title attribute because it is descriptive. C) Rely on email even if duplicates might exist. D) Skip the key and enforce uniqueness later. Show Answer Correct Answer: A) Introduce a new unique identifier as the primary key. 9. Kumpulan objek dengan karakteristik yang sama disebut ..... A) Behaviour. B) Attribute. C) Class. D) Method. E) Data type. Show Answer Correct Answer: C) Class. 10. What is the purpose of reports in Access? A) To delete data. B) To present information in a readable format. C) To encrypt data. D) To create new tables. Show Answer Correct Answer: B) To present information in a readable format. 11. In MongoDB, data is stored in: A) Tables. B) Collections. C) Rows. D) Views. Show Answer Correct Answer: B) Collections. 12. What do databases provide? A) A structured and centralized approach to store and retrieve data efficiently. B) An unstructured and decentralized approach to data management. C) A chaotic and disorganized way to store information. D) A manual and labor-intensive method of data processing. Show Answer Correct Answer: A) A structured and centralized approach to store and retrieve data efficiently. 13. List the different normal forms in database design. A) 1NF, 2NF, 3NF, 6NF. B) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. C) 1NF, 2NF, 3NF, 4NF, 5NF, 8NF. D) 1NF, 2NF, 3NF, 4NF, 5NF, 7NF. Show Answer Correct Answer: B) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. 14. What is the purpose of an E-R diagram in database design? A) To provide a visual representation of how entities are related. B) To store data in a file-based approach. C) To write SQL scripts for database manipulation. D) To create database tables. Show Answer Correct Answer: A) To provide a visual representation of how entities are related. 15. What does a foreign key do? A) Sorts the data. B) Links one table to another. C) Deletes related records. D) Encrypts the table. Show Answer Correct Answer: B) Links one table to another. 16. In which of the following formates data is stored in the database management system? A) Image. B) Text. C) Table. D) Graph. Show Answer Correct Answer: C) Table. 17. How can reports be generated from database queries? A) Reports can be generated by executing SQL queries and formatting the results using reporting tools or programming languages. B) Database queries cannot be used for report generation. C) Reports can only be generated using Excel spreadsheets. D) Reports are generated automatically without any queries. Show Answer Correct Answer: A) Reports can be generated by executing SQL queries and formatting the results using reporting tools or programming languages. 18. Every table in a database must have at least one foreign key. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 19. The primary key in a database: A) Can be duplicated. B) Uniquely identifies each row. C) Is optional. D) Must always contain numbers. Show Answer Correct Answer: B) Uniquely identifies each row. 20. What is a collection of related fields that represents a complete set of information? A) Record. B) Field. C) Database. D) Information. Show Answer Correct Answer: A) Record. 21. What is one key function of a data model? A) Defining how data is organized with entities and relationships. B) Defining automated deployment processes. C) Defining UI models. D) None of the above. Show Answer Correct Answer: A) Defining how data is organized with entities and relationships. 22. Dornel is managing a student database and tries to assign duplicate student ID numbers to a primary key. What happens? A) The database system will accept the duplicates. B) The database will generate an error message. C) The duplicate values will be ignored. D) The duplicates will overwrite the existing values. Show Answer Correct Answer: B) The database will generate an error message. 23. A transaction is a: A) Random query. B) Logical unit of work. C) Single statement only. D) Deadlock prevention. Show Answer Correct Answer: B) Logical unit of work. 24. What operator tests column for the absence of data? A) EXISTS operator. B) NOT operator. C) IS NULL operator. D) None of these. Show Answer Correct Answer: C) IS NULL operator. 25. Which protocol gives each transaction a unique ID based on time? A) Locking protocol. B) Timestamp protocol. C) Wait-die protocol. D) Validation protocol. Show Answer Correct Answer: B) Timestamp protocol. ← 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