This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 7 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 7 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. All items in a column of a table should be ..... A) Heterogeneous. B) Homogeneous. C) All the above. D) None of the above. Show Answer Correct Answer: B) Homogeneous. 2. What is an update/modification anomaly? A) A problem caused by redundant data when updating information. B) A foreign key not referencing a primary key. C) A missing primary key. D) A table with too many records. Show Answer Correct Answer: A) A problem caused by redundant data when updating information. 3. A ..... stores data in tables that are related to each other, like students and courses. A) Relational database. B) Spreadsheet. C) Document store. D) Key-value store. Show Answer Correct Answer: A) Relational database. 4. True or False:Multiple transactions running at the same time must produce the same results even when run sequentially. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 5. Why is the transformation step important in ETL? A) It cleans and organizes data. B) It loads data into the target system. C) It extracts data from various sources. D) It monitors data quality. Show Answer Correct Answer: A) It cleans and organizes data. 6. What does metadata refer to? A) Raw facts of interest. B) Data about data. C) A programming language. D) A type of database. Show Answer Correct Answer: B) Data about data. 7. What is the role of information in decision-making? A) It complicates the decision-making process. B) It serves as the key output that drives decisions. C) It is irrelevant to decision-making. D) It is only useful in scientific research. Show Answer Correct Answer: B) It serves as the key output that drives decisions. 8. Which of the following is a step in normalizing a database? A) Removing repeating groups. B) Adding more redundant data. C) Removing all foreign keys. D) Creating a single table for all data. Show Answer Correct Answer: A) Removing repeating groups. 9. Which command is used to retrieve records from one or more table? A) Delete. B) Insert. C) Drop. D) Select. Show Answer Correct Answer: D) Select. 10. What characteristic does NOT mean that data is in 1NF? A) It is all in one table. B) There is redundancy. C) There is an assigned primary key. D) There are duplicate names. Show Answer Correct Answer: C) There is an assigned primary key. 11. What is the key difference between data and information? A) Data is processed information. B) Information is raw data. C) Data has meaning, while information does not. D) Data and information are the same. Show Answer Correct Answer: A) Data is processed information. 12. What is a record in a database? A) A collection of fields containing information about one specific item. B) The name of a database file. C) A type of query. D) A collection of tables. Show Answer Correct Answer: A) A collection of fields containing information about one specific item. 13. Which of the following options is the purpose of the testing and refinement step in data modeling? A) To define the relationships between tables. B) To implement the database in the software. C) To ensure the database functions correctly and fix any issues. D) To create the conceptual model. Show Answer Correct Answer: C) To ensure the database functions correctly and fix any issues. 14. Which of the following is NOT a type of relationship in a relational database? A) One to One (1:1). B) One to Many (1:M). C) Many to Many (M:M). D) All to All (A:A). Show Answer Correct Answer: D) All to All (A:A). 15. Dalam ERD, kardinalitas menunjukkan: A) Atribut dari entitas. B) Jumlah hubungan antara entitas. C) Nama hubungan antara entitas. D) Jumlah maksimum entitas yang dapat terlibat dalam suatu hubungan. E) Proses normalisasi data. Show Answer Correct Answer: D) Jumlah maksimum entitas yang dapat terlibat dalam suatu hubungan. 16. Which of the following is an example of magnetic storage? A) CD-ROM. B) USB flash drive. C) Hard drive. D) DVD-RW. Show Answer Correct Answer: C) Hard drive. 17. Which of the following best defines a database? A) A structured collection of related data representing real-world aspects. B) A collection of programs. C) A computer hardware component. D) A type of software application. Show Answer Correct Answer: A) A structured collection of related data representing real-world aspects. 18. In data mining, which of the following involves using a series of existing values to determine what other future values will be? A) Forecasting. B) Sequences. C) Classifications. D) Clustering. Show Answer Correct Answer: A) Forecasting. 19. What is meant by concurrency of a database? A) All changes in the database by different users are reflected to all users. B) All transactions of a database are independent. C) Each transaction is considered as a single entity. D) All of the above. Show Answer Correct Answer: A) All changes in the database by different users are reflected to all users. 20. What is the main characteristic of sophisticated end users? A) They use only predefined functions. B) They rarely access the database. C) They only work with personal databases. D) They have high technical expertise and can formulate complex queries. Show Answer Correct Answer: D) They have high technical expertise and can formulate complex queries. 21. A ..... key may store NULL values in it. A) Primary key. B) Foreign key. C) Composite key. D) None of these. Show Answer Correct Answer: B) Foreign key. 22. What is the main purpose of establishing relationships between tables in a relational database? A) To increase redundancy. B) To simplify data entry. C) To connect related data. D) To eliminate the need for attributes. Show Answer Correct Answer: C) To connect related data. 23. A Table is known as a ..... A) RELATION. B) TUPLE. C) ATTRIBUTE. D) LIST. Show Answer Correct Answer: A) RELATION. 24. Which data model is extended from of hierarchical data model? A) Relational. B) Network database model. C) ER model. D) Object Model. Show Answer Correct Answer: B) Network database model. 25. ERD A) An Entity-Relationship Diagram that visually represents entities and their relationships. B) A type of database that stores data in tables. C) A programming language used for database management. D) A diagram that shows the flow of data in a system. Show Answer Correct Answer: A) An Entity-Relationship Diagram that visually represents entities and their relationships. ← 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 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books