This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 82 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 82 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In an ER diagram, what does a diamond shape represent? A) Entity. B) Attribute. C) Relationship. D) Key. Show Answer Correct Answer: C) Relationship. 2. Which of the following programming languages can be used to write application programs that interact with a DBMS? A) Python. B) JavaScript. C) HTML. D) CSS. Show Answer Correct Answer: A) Python. 3. In a table there can be many alternate keys. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 4. What is the best practice for editing records in MS Access? A) Always work in Design View. B) Save after each field modification. C) Edit directly in Datasheet View. D) Only edit through queries. Show Answer Correct Answer: C) Edit directly in Datasheet View. 5. Which join returns rows from one table even if there's no match in another? A) INNER JOIN. B) OUTER JOIN. C) CROSS JOIN. D) NATURAL JOIN. Show Answer Correct Answer: B) OUTER JOIN. 6. What does DDL stand for in SQL? A) Data Distribution Language. B) Data Development Language. C) Data Description Language. D) Data Definition Language. Show Answer Correct Answer: D) Data Definition Language. 7. What is a key characteristic of relational databases? A) Data cannot be related. B) Data is split into several tables. C) All data is stored in one table. D) Data is unstructured. Show Answer Correct Answer: B) Data is split into several tables. 8. What is a subquery and when would you use one? A) A subquery is a type of database index. B) A subquery is a nested query used to retrieve data based on another query's results. C) A subquery is a method for optimizing database performance. D) A subquery is used to create new tables in a database. Show Answer Correct Answer: B) A subquery is a nested query used to retrieve data based on another query's results. 9. What are the two types of data independence? A) Physical data independence and Logical data independence. B) User independence and System independence. C) Internal independence and External independence. D) Static independence and Dynamic independence. Show Answer Correct Answer: A) Physical data independence and Logical data independence. 10. Which is the BEST example of alphabetic data? A) 2025. B) Hanoi. C) A1B2C3. D) @#$ %. Show Answer Correct Answer: B) Hanoi. 11. Which of these is a valid example of a calculated field that should be avoided in database design? A) Name. B) Date of Birth. C) Age. D) ID number. Show Answer Correct Answer: C) Age. 12. What is the primary difference between a file-based system and a database management system (DBMS)? A) A file-based system is faster. B) A DBMS allows for better data organization and retrieval. C) File-based systems are more secure. D) A DBMS can only handle small amounts of data. Show Answer Correct Answer: B) A DBMS allows for better data organization and retrieval. 13. Indicate whether the statement is true or false:A data quality analyst should be proficient in SQL and JavaScript. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 14. The data stored in database at a particular moment of time is called ..... of database. A) Instance. B) Schema. C) E-R Diagram. D) Relation. Show Answer Correct Answer: A) Instance. 15. An attribute in a relation is a foreign key if the ..... key from one relation is used as an attribute in that relation A) Candidate. B) Primary. C) Super. D) Sub. Show Answer Correct Answer: B) Primary. 16. Which of the following is true about BCNF and 3NF? A) BCNF and 3NF are identical in terms of their requirements. B) Every 3NF relation is also in BCNF, but not every BCNF relation is in 3NF. C) Every BCNF relation is also in 3NF, but not every 3NF relation is in BCNF. D) BCNF focuses on functional dependencies, while 3NF focuses on foreign key relationships. Show Answer Correct Answer: C) Every BCNF relation is also in 3NF, but not every 3NF relation is in BCNF. 17. What is durability of a database? A) During a power failure, all committed transactions are cancelled. B) During a power failure, few committed transactions are lost. C) During a power failure, all committed transactions survive. D) None of the above. Show Answer Correct Answer: C) During a power failure, all committed transactions survive. 18. Basis terdiri dari dua kata, yaitu basis dan data. Basis dapat diartikan sebagai ..... A) Tabel. B) Gudang. C) Rekaman. D) Perekaman. E) File. Show Answer Correct Answer: B) Gudang. 19. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). A record in a table represents: A) One field in a table. B) A collection of related fields. C) The entire database. D) A single column of data. Show Answer Correct Answer: B) A collection of related fields. 20. What does Normalisation allow a database designer to do? A) Design their database efficiently, removing the chance of redundancy and inaccuracies. B) Remove additional records from the tables. C) Add as much data as they like. D) Draw an ERD. Show Answer Correct Answer: A) Design their database efficiently, removing the chance of redundancy and inaccuracies. 21. In database terminology, an entity is best defined as: A) A unique identifier for a record. B) A real-world object or concept represented in the database. C) A collection of attributes. D) A set of relationships. Show Answer Correct Answer: B) A real-world object or concept represented in the database. 22. Why do we need a DATABASE SYSTEM? A) To efficiently store and manage small volumes of data. B) To efficiently store, retrieve and manage small volumes of files. C) To efficiently store, retrieve, and manage large volumes of data. D) To efficiently store, retrieve, and manage large volumes of papers. Show Answer Correct Answer: C) To efficiently store, retrieve, and manage large volumes of data. 23. Which key is used to maintain relationship between tables? A) Candidate key. B) Foreign key. C) Primary key. D) Alternate key. Show Answer Correct Answer: B) Foreign key. 24. What is the main goal of data analysis according to Mario Faria? A) To collect data. B) To transform data into conclusions. C) To store data efficiently. D) To visualize data. Show Answer Correct Answer: B) To transform data into conclusions. 25. Which operator checks whether a subquery returns any row? A) ANY. B) ALL. C) EXISTS. D) IN. Show Answer Correct Answer: C) EXISTS. ← 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