This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 41 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 41 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A characteristic or quality that describes a particular database entity is called a(n): A) Field. B) Tuple. C) Key field. D) Attribute. Show Answer Correct Answer: D) Attribute. 2. All of the following are features of a flat file database except A) All records are stored in one place. B) Easy to setup. C) Easy to understand. D) Unique records. Show Answer Correct Answer: D) Unique records. 3. What does a wildcard () do in a query? A) Acts as a placeholder for any number of characters. B) Deletes records automatically. C) Converts text into numbers. D) Sorts records alphabetically. Show Answer Correct Answer: A) Acts as a placeholder for any number of characters. 4. Which of the following is a simple rule which states that at a time only one person can update an object in the database? A) Deadlock. B) Record Locking. C) Redundancy. D) Serialisation. Show Answer Correct Answer: B) Record Locking. 5. The goal of third normal form (3NF) is to A) Eliminate repeating groups. B) Make non-key attributes fully dependent on the primary key. C) Remove transitive dependencies. D) All of these. Show Answer Correct Answer: C) Remove transitive dependencies. 6. Advantages of the database A) Improved access to user data using host and query languages. B) Time is consumed in designing complex database systems. C) Damage to database affects virtually all applications programs. D) Considerable hardware and software start-up costs. E) Extensive conversion costs in shifting from a file-based system to a database system. Show Answer Correct Answer: A) Improved access to user data using host and query languages. 7. Which of the following is NOT one of the ACID properties of database transactions? A) Atomicity. B) Consistency. C) Isolation. D) Duplication. Show Answer Correct Answer: D) Duplication. 8. What is an attribute in a relational database? A) A set of facts or figures in rows and columns. B) A heading for organizing data. C) A unique identifier for a record. D) An automatic validation check. Show Answer Correct Answer: B) A heading for organizing data. 9. What are the key components of a database table? A) Table title, fields, value types, main key, linked keys, views. B) Table name, columns, data types, primary key, foreign keys, indexes. C) Row name, attributes, data formats, unique key, secondary keys, constraints. D) Database name, entries, types of data, main identifier, related keys, triggers. Show Answer Correct Answer: B) Table name, columns, data types, primary key, foreign keys, indexes. 10. Which of these field types would be best to hold a .jpg image? A) Char binary. B) Nchar binary. C) Text. D) Blob. Show Answer Correct Answer: D) Blob. 11. What is the primary purpose of a database form? A) To store raw data only. B) To make data entry and viewing more user-friendly. C) To create complex calculations. D) To delete records permanently. Show Answer Correct Answer: B) To make data entry and viewing more user-friendly. 12. What is the main difference between a spreadsheet and a database? A) A spreadsheet can only store numbers. B) A database is more structured and can handle larger amounts of data. C) A database cannot perform calculations. D) A spreadsheet is used for creating presentations. Show Answer Correct Answer: B) A database is more structured and can handle larger amounts of data. 13. How does a primary key ensure data integrity? A) A primary key can be changed frequently without affecting data. B) A primary key ensures data integrity by uniquely identifying records and preventing duplicates. C) A primary key is used to encrypt sensitive information in the database. D) A primary key allows multiple records to share the same identifier. Show Answer Correct Answer: B) A primary key ensures data integrity by uniquely identifying records and preventing duplicates. 14. A raw fact, such as an invoice date, is known as ..... A) Information. B) A record. C) A relationship. D) Data. Show Answer Correct Answer: D) Data. 15. Berikut ini perintah yang ada pada Data Manipulation Language adalah kecuali ..... A) Select. B) Insert. C) Update. D) Delete. E) Create. Show Answer Correct Answer: E) Create. 16. What is a join in SQL? A) A join in SQL is a method to create new tables. B) A join in SQL is used to delete rows from a table. C) A join in SQL is used to combine rows from two or more tables based on a related column. D) A join in SQL is a function to sort data in a single table. Show Answer Correct Answer: C) A join in SQL is used to combine rows from two or more tables based on a related column. 17. Fabia is designing a database for her small business. She wants to ensure that the data stored in each field is efficient and doesn't take up unnecessary space. What is the purpose of the "Field Size" property in his database? A) To define the maximum number of records in a table. B) To set the length of data stored in the field. C) To determine the type of data in the field. D) To organize records by size. Show Answer Correct Answer: B) To set the length of data stored in the field. 18. Which index type supports geospatial queries? A) Text index. B) 2dsphere index. C) Compound index. D) Hashed index. Show Answer Correct Answer: B) 2dsphere index. 19. A ..... is represented as rows in a table. A) Field. B) Attribute. C) Record. D) Candidate key. Show Answer Correct Answer: C) Record. 20. An attribute that names or identifies entity instances is a(n): A) Entity. B) Attribute. C) Identifier. D) Relationship. Show Answer Correct Answer: C) Identifier. 21. Which of the following indicates the maximum number of entities that can be involved in a relationship? A) Minimum cardinality. B) Maximum cardinality. C) ERD. D) Greater Entity Count (GEC). Show Answer Correct Answer: B) Maximum cardinality. 22. What is a parameter query? A) A query that asks for user input before running. B) A query that automatically updates records. C) A query that deletes unwanted data. D) A query that only works with primary keys. Show Answer Correct Answer: A) A query that asks for user input before running. 23. What does the IN clause do in SQL? A) It selects rows that match a list of values. B) It updates rows in a table. C) It deletes rows from a table. D) It creates a new table. Show Answer Correct Answer: A) It selects rows that match a list of values. 24. Which clause is used to filter records based on a specified condition? A) GROUP BY. B) WHERE. C) HAVING. D) ORDER BY. Show Answer Correct Answer: B) WHERE. 25. What is the main focus of the relational model? A) Class diagrams. B) Data stored in tables with relationships. C) Binary data trees. D) Memory indexing. Show Answer Correct Answer: B) Data stored in tables with 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 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