This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 42 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 42 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Entity instance of one type related to many entity instances of another type? A) One-to-One Relationship. B) One-to-Many Relationship. C) Many-to-Many Relationship. D) Composite Relationship. Show Answer Correct Answer: B) One-to-Many Relationship. 2. A data may contain any ..... A) Character. B) Text. C) Number. D) All the above. Show Answer Correct Answer: D) All the above. 3. A database is MOST useful when data needs to be: A) Written in ASCII code. B) Randomly stored without structure. C) Organized, searched, and updated quickly. D) Converted into symbolic language. Show Answer Correct Answer: C) Organized, searched, and updated quickly. 4. Which method is used to insert multiple documents at once? A) Insert(). B) InsertOne(). C) InsertMany(). D) BulkInsert(). Show Answer Correct Answer: C) InsertMany(). 5. In relational databases, what is a 'tuple'? A) A type of index. B) A column of data. C) A row in a table. D) A SQL operator. Show Answer Correct Answer: C) A row in a table. 6. What is the tiniest nugget of data in a database, representing a characteristic or attribute of an entity? A) Row. B) Database. C) Field. D) Table. Show Answer Correct Answer: C) Field. 7. Which schedule is always serializable and avoids cascading aborts? A) Recoverable. B) Strict. C) Cascaded. D) Non-recoverable. Show Answer Correct Answer: B) Strict. 8. The HAVING is similar to WHERE, but it can operate on the GROUP BY aggregate functions, whereas WHERE operates only on columns A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 9. Which of the following is a valid data type in SQL? A) Varchar. B) Text. C) Character. D) String. Show Answer Correct Answer: A) Varchar. 10. What is the function of the GROUP BY clause in SQL? A) To filter records. B) To group rows that have the same values in specified columns. C) To sort the result set. D) To join multiple tables. Show Answer Correct Answer: B) To group rows that have the same values in specified columns. 11. Data ..... occurs when the same data is duplicated in multiple files of a database. A) Redundancy. B) Repetition. C) Independence. D) Partitions. Show Answer Correct Answer: A) Redundancy. 12. Which operation is used for selecting a subset with tuples according to a given condition? A) Select. B) Project. C) Product. D) Union. Show Answer Correct Answer: A) Select. 13. What are some common data manipulation operations? A) Transcribing, encoding, compressing. B) Storing, deleting, indexing. C) Filtering, sorting, aggregating, merging, reshaping. D) Calculating, visualizing, exporting. Show Answer Correct Answer: C) Filtering, sorting, aggregating, merging, reshaping. 14. Jika sebuah kolom didefinisikan dengan 'NOT NULL', apa artinya? A) Kolom tersebut harus berisi nilai unik. B) Kolom tersebut tidak boleh kosong. C) Kolom tersebut dapat berisi nilai kosong. D) Kolom tersebut adalah kunci utama. Show Answer Correct Answer: B) Kolom tersebut tidak boleh kosong. 15. Data redundancy may lead to data inconsistency. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 16. ASCII codes are important because they allow computers to: A) Store numbers more quickly. B) Display characters by linking binary codes to letters, digits, and symbols. C) Format tables into readable reports. D) Translate data into databases. Show Answer Correct Answer: B) Display characters by linking binary codes to letters, digits, and symbols. 17. Explain the implementation of stored procedures in databases. A) Stored procedures are implemented using a web browser. B) Stored procedures in databases are implemented using a specific programming language such as SQL. They are precompiled and stored in the database for reuse, which helps improve performance and security. C) Stored procedures are implemented using a spreadsheet software. D) Stored procedures are implemented using a video editing software. Show Answer Correct Answer: B) Stored procedures in databases are implemented using a specific programming language such as SQL. They are precompiled and stored in the database for reuse, which helps improve performance and security. 18. Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of ..... A) Data Types. B) Filters. C) Sorts. D) Validations. Show Answer Correct Answer: A) Data Types. 19. DBMS stands for A) Database manipulation system. B) Database Modifying system. C) Database Management System. D) Database minimising system. Show Answer Correct Answer: C) Database Management System. 20. Which of the following is the best definition of a field in a database? A) A single piece of data within a record. B) A table in the database. C) A primary key. D) A relationship between tables. Show Answer Correct Answer: A) A single piece of data within a record. 21. A DBMS that combines a DBMS and an application builder is: A) Microsoft SQL Server. B) Microsoft Access. C) IBM DB2. D) Oracle by Oracle Corporation. Show Answer Correct Answer: B) Microsoft Access. 22. What is the purpose of Queries in a database? A) Requests made to the database to retrieve, modify, or manipulate data using SQL. B) Requests made to the database to shut down the system. C) Requests made to the database to install new software. D) Requests made to the database to delete all data. Show Answer Correct Answer: A) Requests made to the database to retrieve, modify, or manipulate data using SQL. 23. Which of the following describes a data dictionary? A) A list of all users in the database. B) A hidden part of the database containing metadata. C) A backup of the database. D) A report generated from the database. Show Answer Correct Answer: B) A hidden part of the database containing metadata. 24. A one-to-many relationship means: A) Each record in table A can have many matching records in table B. B) Each record in table B can have many matching records in table A. C) Each table has only one record. D) There is no relationship between tables. Show Answer Correct Answer: A) Each record in table A can have many matching records in table B. 25. How might a school database help the school run more smoothly? A) By providing lunch recipes. B) By organizing student and teacher information. C) By controlling the school's temperature. D) By writing homework assignments. Show Answer Correct Answer: B) By organizing student and teacher information. ← 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