This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 31 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 31 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In which Normal Form should you eliminate repeating groups? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of these. Show Answer Correct Answer: A) First Normal Form (1NF). 2. You are designing a system to sell subscriptions for online revision guides. What should be your first step when identifying entities? A) Look at the data that must be recorded. B) Choose the database management system. C) Create tables with surrogate primary keys. D) Design user interface wireframes first. Show Answer Correct Answer: A) Look at the data that must be recorded. 3. What is non-structured data? A) Data that is always numerical. B) Data that fits neatly into rows and columns. C) Data that doesn't have a clear order or pattern. D) Data that is always textual. Show Answer Correct Answer: C) Data that doesn't have a clear order or pattern. 4. Which command is used to remove all rows from a table but retain the structure? A) DROP. B) DELETE. C) TRUNCATE. D) REMOVE. Show Answer Correct Answer: C) TRUNCATE. 5. Which common database challenge is illustrated by a person receiving multiple copies of a catalog each addressed to a slightly different variation of their full name? A) Data normalization. B) Data redundancy. C) Data inconsistency. D) Data duplication. Show Answer Correct Answer: C) Data inconsistency. 6. In a relational database, what connects two tables together? A) A shared primary key. B) A random data entry. C) A password. D) A separate software. Show Answer Correct Answer: A) A shared primary key. 7. Which of the following is NOT a reason for manual data entry mistakes? A) Misreading the original data. B) Input error with long codes. C) Transposition error. D) Automatic data validation. Show Answer Correct Answer: D) Automatic data validation. 8. Which SQL statement is used to delete data from a database? A) COLLAPSE. B) DELETE. C) REMOVE. D) DROP. Show Answer Correct Answer: B) DELETE. 9. Choose the correct data type for storing an email address. A) Integer. B) Boolean. C) String. D) FloatTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: C) String. 10. The DROP TABLE statement: A) Deletes the table structure only. B) Deletes the table structure along with the table data. C) Works whether or not referential integrity constraints would be violated. D) Is not an SQL Statement. Show Answer Correct Answer: B) Deletes the table structure along with the table data. 11. Which of the following is not one of the techniques used in web mining? A) Content mining. B) Structure mining. C) Server mining. D) Usage mining. Show Answer Correct Answer: C) Server mining. 12. Which benefit is directly related to the concept of logical data independence? A) Ability to move files between disks without changing queries. B) Ability to change indexes without changing any programs. C) Ability to change table structures without changing user views. D) Ability to compress backup files. Show Answer Correct Answer: C) Ability to change table structures without changing user views. 13. Physical data independence is A) The ability to modify the conceptual schema without having alteration in external schema or application programs. B) The ability to modify the physical schema without causing the conceptual schema application programs to be rewritten. C) None of these. D) All of these. Show Answer Correct Answer: B) The ability to modify the physical schema without causing the conceptual schema application programs to be rewritten. 14. What is the purpose of validation in a database? A) To represent the structure of a database. B) To automatically check individual fields to reduce errors. C) To link tables together. D) To format data input. Show Answer Correct Answer: B) To automatically check individual fields to reduce errors. 15. What is a data-entry error? A) A unique identifier for a record. B) Error that occurs when data is being entered into a database. C) Unnecessary repetition of data. D) A table structure in a database. Show Answer Correct Answer: B) Error that occurs when data is being entered into a database. 16. Which of the following is a Data Manipulation Language (DML) command? A) CREATE. B) DELETE. C) DROP. D) ALTER. Show Answer Correct Answer: B) DELETE. 17. What is the difference between a primary key and a foreign key? A) A primary key can be null, while a foreign key cannot be null. B) A primary key is always a string, while a foreign key is always an integer. C) A primary key is used for indexing, while a foreign key is used for sorting. D) A primary key uniquely identifies records in a table, while a foreign key links records between tables. Show Answer Correct Answer: D) A primary key uniquely identifies records in a table, while a foreign key links records between tables. 18. Orang yang mengalasis system dengan cara mempelajari masalah yang timbul dankebutuhan pengguna system disebut ..... A) Analisis system. B) Analisis kebutuhan. C) Kebutuhan fungsional. D) Analis system. E) Kebutuhan nonfungsional. Show Answer Correct Answer: A) Analisis system. 19. What is the purpose of database design? A) To design graphics for the database. B) To write code for database queries. C) To create a physical model of the database. D) To create a blueprint for organizing data in a database system. Show Answer Correct Answer: D) To create a blueprint for organizing data in a database system. 20. Indicate whether the statement is true or false:Core operational transaction systems provide data to data warehouses. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 21. To simplify data storage and reduce redundancy, large tables are broken into smaller related tables. This process is called: A) Normalization. B) Integrity Checking. C) Data Merging. D) Sorting. Show Answer Correct Answer: A) Normalization. 22. How do you drop a view in SQL? A) DROP TABLE view name;. B) DROP VIEW view name;. C) DELETE VIEW view name;. D) REMOVE VIEW view name;. Show Answer Correct Answer: B) DROP VIEW view name;. 23. Which of the following is NOT a database object? A) Table. B) Graph. C) Query. D) Report. Show Answer Correct Answer: B) Graph. 24. What is the purpose of using macros in Access? A) The purpose of using macros in Access is to automate tasks and enhance functionality. B) To create complex queries and reports. C) To store large amounts of data efficiently. D) To design user interfaces for applications. Show Answer Correct Answer: A) The purpose of using macros in Access is to automate tasks and enhance functionality. 25. ..... is a top-down approach in which one higher level entity can be divided into two lower level entities. A) Aggregation. B) Specialization. C) Generalization. D) None of the above. Show Answer Correct Answer: B) Specialization. ← 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