This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 10 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is the most prominent data manipulation language today? A) Access. B) DB2. C) SQL. D) None of the above. Show Answer Correct Answer: C) SQL. 2. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as ..... A) Data Model. B) E-R Model. C) DBMS. D) All of the above. Show Answer Correct Answer: D) All of the above. 3. Which of the following is a benefit of using a database? A) It can store only text data. B) It can only be used by one person at a time. C) It allows for efficient data retrieval and management. D) It cannot be updated. Show Answer Correct Answer: C) It allows for efficient data retrieval and management. 4. What is the full form of DDL? A) Dynamic Data Language. B) Detailed Data Language. C) Data Definition Language. D) Data Derivation Language. Show Answer Correct Answer: C) Data Definition Language. 5. Which of the following data types is best suited for storing phone numbers? A) Numeric. B) Text. C) Currency. D) Logical. Show Answer Correct Answer: B) Text. 6. A transaction first checks the price of an item, then updates the item's stock level. Which isolation level guarantees that the price cannot be changed by another transaction between the SELECT and the UPDATE on the same row? A) READ UNCOMMITTED. B) READ COMMITTED. C) REPEATABLE READ. D) ATOMIC. Show Answer Correct Answer: C) REPEATABLE READ. 7. Validation rule to ensure data must be entered into that field ..... A) Is Not Null. B) Is Complete. C) Is Not Empty. D) Is Not Nothing. Show Answer Correct Answer: A) Is Not Null. 8. What is the primary difference between data and information? A) Data is the raw material, while information is the processed output. B) Data is processed, while information is raw facts. C) Data is always numerical, while information is always descriptive. D) Data is irrelevant, while information is always accurate. Show Answer Correct Answer: A) Data is the raw material, while information is the processed output. 9. What is the role of a primary key in a database table? A) To store duplicate values. B) To uniquely identify each record. C) To delete unnecessary data. D) To create a relationship between databases. Show Answer Correct Answer: B) To uniquely identify each record. 10. When you omit the field list in an INSERT statement, what MUST be true? A) All values must be inserted in the correct order. B) A WHERE condition must be used. C) Only text values can be added. D) The table must be empty. Show Answer Correct Answer: A) All values must be inserted in the correct order. 11. List some common data warehousing tools. A) SAP HANA Cloud. B) Some common data warehousing tools are Amazon Redshift, Google BigQuery, Snowflake, Microsoft Azure Synapse Analytics, and Teradata. C) Oracle Data Lake. D) IBM Db2 Warehouse. Show Answer Correct Answer: B) Some common data warehousing tools are Amazon Redshift, Google BigQuery, Snowflake, Microsoft Azure Synapse Analytics, and Teradata. 12. Which of the following is a benefit of using a database over file-based systems? A) Data Redundancy. B) Data Sharing. C) Slower processing. D) Complex queries. Show Answer Correct Answer: B) Data Sharing. 13. What is the focus of a logical ERD? A) Structure and relationships between entities. B) Actual database implementation. C) Only the attributes of entities. D) Data types and constraints. Show Answer Correct Answer: A) Structure and relationships between entities. 14. What does the term 'data abstraction' mean? A) Conceptual representation of data. B) Details of how data is stored. C) Data that is not important. D) Data that is always changing. Show Answer Correct Answer: A) Conceptual representation of data. 15. What is one benefit of using forms in databases? A) They make it harder to work with individual records. B) They offer less flexibility in organizing fields. C) They allow updating parent and child records simultaneously. D) They prevent any updates to records. Show Answer Correct Answer: C) They allow updating parent and child records simultaneously. 16. Which statement best defines referential integrity in a relational database? A) A foreign key may reference any table row anywhere. B) A foreign key must reference an existing related row. C) A primary key must change when rows are deleted. D) A composite key must be used in every relation. Show Answer Correct Answer: B) A foreign key must reference an existing related row. 17. Data once processed is called ..... A) Raw Facts. B) Data. C) Information. D) Database. Show Answer Correct Answer: C) Information. 18. The year when the first internet applications for databases appeared? A) 1994. B) 1995. C) 1990. D) 1996. E) 1999. Show Answer Correct Answer: B) 1995. 19. What are the key components of a data warehousing architecture? A) Data mining and analytics. B) Key components of a data warehousing architecture include data sources, ETL processes, data warehouse, data marts, and presentation layer. C) Real-time data processing. D) Data lakes and cloud storage. Show Answer Correct Answer: B) Key components of a data warehousing architecture include data sources, ETL processes, data warehouse, data marts, and presentation layer. 20. In data mining, which of the following involves events linked over time? A) Associations. B) Sequences. C) Classifications. D) Clustering. Show Answer Correct Answer: B) Sequences. 21. True or False:(102, 'John', 'Physics') is an instance of the Students table. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 22. Which SQL statement is used to retrieve data from a database? A) GET. B) SELECT. C) FETCH. D) READ. Show Answer Correct Answer: B) SELECT. 23. What does OLTP stand for? A) Operational Language Transaction Processing. B) Open Language Transaction Protocol. C) Offline Transaction Processing. D) Online Transaction Processing. Show Answer Correct Answer: D) Online Transaction Processing. 24. Why might a file cabinet be used as an analogy for a database structure? A) Because both are used for cooking. B) Because both store and organize information in a systematic way. C) Because both are made of metal. D) Because both are used for transportation. Show Answer Correct Answer: B) Because both store and organize information in a systematic way. 25. Which ACID property ensures that committed data remains even after a crash? A) Consistency. B) Isolation. C) Atomicity. D) Durability. Show Answer Correct Answer: D) Durability. ← 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 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books