This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 44 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 44 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which SQL operator compares a value with all values in a subquery? A) EXISTS. B) ANY. C) ALL. D) IN. Show Answer Correct Answer: C) ALL. 2. How are "Fields" defined in a Microsoft Excel flat file database? A) The ability to keep data consistent with relevant raw facts. B) The ability to store, sort, and search data. C) The single cell bisecting row and column. D) Categories of data being stored within the table. Show Answer Correct Answer: C) The single cell bisecting row and column. 3. NULL is A) The same as 0 for an integer. B) The same as blank for a character. C) Both A and B. D) Not a value. Show Answer Correct Answer: D) Not a value. 4. What is the benefit of using an ER model before creating a physical database? A) Helps with software coding. B) Helps design logical relationships and structure. C) Improves file size. D) Adds storage space. Show Answer Correct Answer: B) Helps design logical relationships and structure. 5. A relation is in 1NF if it doesn't contain any ..... ? A) Determinants. B) Repeating groups. C) Null values in primary key fields. D) Functional dependencies. Show Answer Correct Answer: B) Repeating groups. 6. ..... is a container of database objects in Microsoft Access. A) Field. B) Database. C) Table. D) Form. Show Answer Correct Answer: C) Table. 7. Select * from ..... ; A) Databasename. B) Fieldname. C) Tablename. D) None of these. Show Answer Correct Answer: C) Tablename. 8. Which of the following is a characteristic of unstructured data? A) Can only be stored in relational databases. B) Requires a fixed schema. C) Exists in its original state. D) Stored in a predefined format. Show Answer Correct Answer: C) Exists in its original state. 9. With reference to SQL, identify the invalid data type. A) Date. B) Integer. C) Varchar. D) Month. Show Answer Correct Answer: D) Month. 10. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). Which of the following best defines a field? A) A collection of tables. B) A single category of data, such as "Age". C) A complete record about one student. D) A type of software program. Show Answer Correct Answer: B) A single category of data, such as "Age". 11. What is the primary key in a table? A) A data structure built from one or more columns in a database table. B) A set of attributes that form a primary key. C) A unique identifier for a table. D) An individual data item stored for an entity. Show Answer Correct Answer: C) A unique identifier for a table. 12. Which of the following is a real-world example of a database in a library? A) Books table. B) Library building. C) Reading room. D) Library card. Show Answer Correct Answer: A) Books table. 13. Dalam diagram use case, aktor biasanya digambarkan dengan: A) Lingkaran. B) Persegi panjang. C) Figur tongkat. D) Belah ketupat. E) Segitiga. Show Answer Correct Answer: C) Figur tongkat. 14. ..... ensures users can access data at the same time. A) Data consistency. B) Data concurrency. C) Data validation. D) Data verification. Show Answer Correct Answer: B) Data concurrency. 15. A database relationship is established by: A) Using foreign keys. B) Adding duplicate records. C) Deleting tables. D) Changing field names. Show Answer Correct Answer: A) Using foreign keys. 16. Which property ensures "all or nothing" execution? A) Consistency. B) Atomicity. C) Isolation. D) Durability. Show Answer Correct Answer: B) Atomicity. 17. Perintah berikut ada dalam Bahasa Data Defintion Language, kecuali ..... A) Create. B) Alter. C) Rename. D) Drop. E) Select. Show Answer Correct Answer: E) Select. 18. A record in a database represents: A) A collection of unrelated data. B) A single piece of information. C) Information related to one entity. D) A random assortment of fields. Show Answer Correct Answer: B) A single piece of information. 19. Which of the following is a common DBMS? A) MS-Access, Oracle, MySQL, Microsoft SQL Server. B) Adobe Photoshop, Google Chrome, Microsoft Word, Spotify. C) Facebook, Twitter, Instagram, Snapchat. D) Java, Python, C++, Ruby. Show Answer Correct Answer: A) MS-Access, Oracle, MySQL, Microsoft SQL Server. 20. In a hospital database, which table would contain information about patients? A) Appointments Table. B) Doctors Table. C) Patients Table. D) Prescriptions Table. Show Answer Correct Answer: C) Patients Table. 21. Which type of data model is simpler and easier to read? A) Conceptual Data Model. B) Logical Data Model. C) Hierarchical Data Model. D) Physical Data Model. Show Answer Correct Answer: A) Conceptual Data Model. 22. A database is a ..... collection of related data. A) Random. B) Temporary. C) Organized. D) Unprocessed. Show Answer Correct Answer: C) Organized. 23. Related fields in a database are grouped to form a A) Data file. B) Data record. C) Menu. D) Bank. Show Answer Correct Answer: B) Data record. 24. How does a foreign key function in a database? A) It stores user data. B) It encrypts sensitive information. C) It connects one table to another. D) It identifies a unique record. Show Answer Correct Answer: C) It connects one table to another. 25. ER models are useful for designing the structure of relational databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. ← 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