This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 49 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 49 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which type of database is better for relating different types of information? A) Relational database. B) NoSQL database. C) In-memory database. D) Flat file database. Show Answer Correct Answer: A) Relational database. 2. What is the purpose of an entity-relationship (E-R) diagram? A) To write SQL queries. B) To visualize the database structure. C) To manage user access. D) To store data. Show Answer Correct Answer: B) To visualize the database structure. 3. When working with databases, which SQL statement is used to choose a specific database for operations? A) SELECT DATABASE. B) USE. C) SHOW DATABASE. D) OPEN DATABASE. Show Answer Correct Answer: B) USE. 4. Apa perbedaan antara tag dan dalam HTML? A) Tag digunakan untuk mengatur tata letak halaman sedangkan tag digunakan untuk menambahkan gambar. B) Tag digunakan untuk membuat elemen inline sedangkan tag digunakan untuk membuat blok elemen. C) Tag digunakan untuk menampilkan teks sedangkan tag digunakan untuk membuat hyperlink. D) Tag digunakan untuk membuat blok elemen sedangkan tag digunakan untuk membuat inline elemen. Show Answer Correct Answer: D) Tag digunakan untuk membuat blok elemen sedangkan tag digunakan untuk membuat inline elemen. 5. How would you establish a relationship between the 'Teachers' and 'Classes' tables? A) Using a secondary key. B) Using the TeacherID as a foreign key in the 'Classes' table. C) Using a new table. D) Using StudentID in both tables. Show Answer Correct Answer: B) Using the TeacherID as a foreign key in the 'Classes' table. 6. Paper-based is an example of physical database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 7. A non key attribute, whose values are derived from the primary key of some other table is known as A) Alternate key. B) Foreign key. C) Candidate key. D) None. Show Answer Correct Answer: B) Foreign key. 8. Which of the following is an example of alphabetic data? A) 12345. B) A12345. C) John Doe. D) %&$. Show Answer Correct Answer: C) John Doe. 9. What is the purpose of defining validation rules for fields in a database? A) To limit the number of records. B) To ensure data accuracy and integrity. C) To make the database visually appealing. D) To define primary keysTagsLO2. Show Answer Correct Answer: B) To ensure data accuracy and integrity. 10. What is the role of an index in a database? A) To delete records. B) To speed up data operations. C) To create new tables. D) To store images. Show Answer Correct Answer: B) To speed up data operations. 11. Which of the following best describes data abstraction? A) The process of hiding internal database complexities from users. B) Writing user interfaces. C) Making backups. D) Encrypting data. Show Answer Correct Answer: A) The process of hiding internal database complexities from users. 12. What are the benefits of Triggers? A) Generating some derived column values automatically. B) Enforcing referential integrity. C) Synchronous replication of tables. D) All of the above. Show Answer Correct Answer: D) All of the above. 13. Can some attributes accept a "null" value? A) Yes. B) No. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes. 14. Which of the following is NOT an acronym of sub languages of SQL A) DQL. B) DHL. C) DDL. D) DML. Show Answer Correct Answer: B) DHL. 15. Which data type should you use to store a phone number in an MS Access table? A) Number. B) Text (Short Text). C) Currency. D) Date/Time. Show Answer Correct Answer: B) Text (Short Text). 16. What is a database transaction? A) A financial exchange between two databases. B) The process of backing up a database. C) A logical unit of work that must be completed entirely or not at all. D) The act of querying a database. Show Answer Correct Answer: C) A logical unit of work that must be completed entirely or not at all. 17. Which clause filters rows before aggregation? A) WHERE. B) HAVING. C) FILTER. D) GROUP BY. Show Answer Correct Answer: A) WHERE. 18. Hierarchical model was developed by ..... A) Microsoft Corporation. B) IBM. C) Bell Labs. D) None of the above. Show Answer Correct Answer: B) IBM. 19. Which of the following is an advantage of using a database? A) Reduced Data Redundancy. B) Data Redundancy. C) Data Inconsistency. D) Data cannot be changed easily. Show Answer Correct Answer: A) Reduced Data Redundancy. 20. Explain the purpose of Data Query Language (DQL). A) The purpose of Data Query Language (DQL) is to create and delete database tables. B) The purpose of Data Query Language (DQL) is to query and retrieve data from a database. C) The purpose of Data Query Language (DQL) is to manage user permissions in a database. D) The purpose of Data Query Language (DQL) is to update and modify database structures. Show Answer Correct Answer: B) The purpose of Data Query Language (DQL) is to query and retrieve data from a database. 21. Which is NOT one of the most common types of SQL CHECK constraints? A) System date. B) Range checks. C) Lists of values. D) Comparing one column value to another within the same table. Show Answer Correct Answer: A) System date. 22. A household appliances manufacturer has hired you to help analyze its social media data sets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data? A) Text mining tools. B) Sentiment analysis software. C) Web mining technologies. D) Data mining software. Show Answer Correct Answer: B) Sentiment analysis software. 23. What is the primary purpose of the SELECT statement in DML? A) To insert new records. B) To update existing records. C) To retrieve data from the database. D) To remove data from a table. Show Answer Correct Answer: C) To retrieve data from the database. 24. Which of the following is NOT a relationship type? A) One-to-Many. B) Many-to-One. C) None-to-Many. D) Many-to-Many. Show Answer Correct Answer: C) None-to-Many. 25. Which level of DBMS architecture defines how data is stored physically? A) Conceptual level. B) Internal level. C) External level. D) Application level. Show Answer Correct Answer: B) Internal level. ← 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