This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 45 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 45 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which SQL command would you use to add a new row to a table? A) UPDATE. B) ADD. C) APPEND. D) INSERT. Show Answer Correct Answer: D) INSERT. 2. An entity is represented by what in a database? A) Table. B) Row. C) Column. D) Cell. Show Answer Correct Answer: A) Table. 3. What is an attribute in a database? A) A characteristic or property of an entity in a database. B) A table in a database. C) A query in a database. D) A relationship between two entities in a database. Show Answer Correct Answer: A) A characteristic or property of an entity in a database. 4. Why is it important to choose the correct data type for a field in a database? A) It is important to ensure data integrity and optimize performance. B) It allows for easier data visualization techniques. C) It simplifies the process of data entry and retrieval. D) It helps in creating user-friendly interfaces. Show Answer Correct Answer: A) It is important to ensure data integrity and optimize performance. 5. What are the common data types used in database tables? A) Character, Decimal, Time, List, Set. B) Text, Number, DateTime, Array, Object. C) Integer, Float, String, Date, Boolean. D) Currency, Image, File, URL, Email. Show Answer Correct Answer: C) Integer, Float, String, Date, Boolean. 6. Which SQL command is used to create a new table? A) NEW table. B) INSERT table. C) CREATE table. D) ADD table. Show Answer Correct Answer: C) CREATE table. 7. Which of the following is an advantage of a flat file database? A) Eliminates redundancy. B) Simple and easy to implement. C) Allows for complex queries. D) Supports multiple relationships. Show Answer Correct Answer: B) Simple and easy to implement. 8. The ..... operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple A) Select. B) Join. C) Union. D) Intersection. Show Answer Correct Answer: B) Join. 9. Database Management System (DBMS) A) Software used to create, manage, and control databases. B) A type of hardware used for data storage. C) A programming language for database queries. D) A network protocol for data transmission. Show Answer Correct Answer: A) Software used to create, manage, and control databases. 10. What are the key components of a database? A) Data, Tables, Queries. B) Data, Object-Oriented Databases, NoSQL Databases. C) Data, Database Management System (DBMS), Database Schema. D) Primary Key, Foreign Key, Queries. Show Answer Correct Answer: C) Data, Database Management System (DBMS), Database Schema. 11. A subquery inside another query that references outer query columns is called: A) Inline View. B) Correlated Subquery. C) Simple Subquery. D) Nested Subquery. Show Answer Correct Answer: B) Correlated Subquery. 12. Which of the following is an example of a primary key? A) Student candidate number. B) Student name. C) Student address. D) Student age. Show Answer Correct Answer: A) Student candidate number. 13. What can queries perform on data besides extracting it? A) Encrypting data. B) Performing calculations like totals and averages. C) Deleting data. D) Creating new tables. Show Answer Correct Answer: B) Performing calculations like totals and averages. 14. Entities can be associated with one another in which of the following? A) Entities. B) Attributes. C) Identifiers. D) Relationships. Show Answer Correct Answer: D) Relationships. 15. Which of the following technologies would you use to analyze the social media data collected by a major online retailer? A) OLAP. B) Data warehouse. C) Data mart. D) Hadoop. Show Answer Correct Answer: D) Hadoop. 16. The SQL used by front-end application programs to request data from the DBMS is called ..... A) A. DML. B) B .DDL. C) C .VDL. D) D. SDL. Show Answer Correct Answer: A) A. DML. 17. In a one-to-one relationship, how many records in one table can be associated with records in another table? A) None. B) One. C) Two. D) Many. Show Answer Correct Answer: B) One. 18. Which type of relationship is the most common in databases? A) One to one. B) One to many. C) Many to many. D) None of the above. Show Answer Correct Answer: B) One to many. 19. Which data type can store up to 1 gigabyte of data? A) Text. B) Long Text. C) Date/Time. D) Number. Show Answer Correct Answer: B) Long Text. 20. An attribute in a database refers to: A) A table's structure. B) A specific characteristic of an entity. C) A relationship between tables. D) The database software. Show Answer Correct Answer: B) A specific characteristic of an entity. 21. Composite key A) A primary key composed of two or more columns. B) A unique identifier for a single column. C) A foreign key that references multiple tables. D) A key that allows duplicate values in a column. Show Answer Correct Answer: A) A primary key composed of two or more columns. 22. The command to update multiple documents is: A) UpdateOne(). B) UpdateMany(). C) UpdateAll(). D) BulkUpdate(). Show Answer Correct Answer: B) UpdateMany(). 23. Perintah SQL yang benar untuk membuat database baru bernama 'siswa' adalah ..... A) CREATE DATABASE siswa;. B) MAKE DATABASE siswa;. C) NEW DATABASE siswa;. D) ADD DATABASE siswa;. Show Answer Correct Answer: A) CREATE DATABASE siswa;. 24. Entity in a database A) A type of database management system. B) An object or thing that can have data stored about it. C) A method for querying data. D) A programming language used for database operations. Show Answer Correct Answer: B) An object or thing that can have data stored about it. 25. Which of the following is a characteristic of a digital database? A) It can only store text data. B) It is organized and easily searchable. C) It requires physical space for storage. D) It is not accessible remotely. Show Answer Correct Answer: B) It is organized and easily searchable. ← 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