This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 13 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 13 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which command is used to remove all rows from a table but retain the structure? A) DROP. B) REMOVE. C) DELETE. D) TRUNCATE. Show Answer Correct Answer: D) TRUNCATE. 2. 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 duplication. B) Data normalization. C) Data redundancy. D) Data inconsistency. Show Answer Correct Answer: D) Data inconsistency. 3. 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. 4. Which of the following is NOT a reason for manual data entry mistakes? A) Automatic data validation. B) Transposition error. C) Misreading the original data. D) Input error with long codes. Show Answer Correct Answer: A) Automatic data validation. 5. Which SQL statement is used to delete data from a database? A) COLLAPSE. B) DELETE. C) DROP. D) REMOVE. Show Answer Correct Answer: B) DELETE. 6. Choose the correct data type for storing an email address. A) String. B) Boolean. C) FloatTagsDOK Level 2:Skill/Concept. D) Integer. Show Answer Correct Answer: A) String. 7. The DROP TABLE statement: A) Is not an SQL Statement. B) Deletes the table structure only. C) Works whether or not referential integrity constraints would be violated. D) Deletes the table structure along with the table data. Show Answer Correct Answer: D) Deletes the table structure along with the table data. 8. Which of the following is not one of the techniques used in web mining? A) Server mining. B) Content mining. C) Usage mining. D) Structure mining. Show Answer Correct Answer: A) Server mining. 9. 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 compress backup files. D) Ability to change table structures without changing user views. Show Answer Correct Answer: D) Ability to change table structures without changing user views. 10. 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. 11. 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. 12. What is a data-entry error? A) Error that occurs when data is being entered into a database. B) Unnecessary repetition of data. C) A table structure in a database. D) A unique identifier for a record. Show Answer Correct Answer: A) Error that occurs when data is being entered into a database. 13. Which of the following is a Data Manipulation Language (DML) command? A) DROP. B) CREATE. C) ALTER. D) DELETE. Show Answer Correct Answer: D) DELETE. 14. 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 used for indexing, while a foreign key is used for sorting. C) A primary key uniquely identifies records in a table, while a foreign key links records between tables. D) A primary key is always a string, while a foreign key is always an integer. Show Answer Correct Answer: C) A primary key uniquely identifies records in a table, while a foreign key links records between tables. 15. Orang yang mengalasis system dengan cara mempelajari masalah yang timbul dankebutuhan pengguna system disebut ..... A) Analis system. B) Kebutuhan nonfungsional. C) Analisis kebutuhan. D) Kebutuhan fungsional. E) Analisis system. Show Answer Correct Answer: E) Analisis system. 16. What is the purpose of database design? A) To create a physical model of the database. B) To design graphics for the database. C) To create a blueprint for organizing data in a database system. D) To write code for database queries. Show Answer Correct Answer: C) To create a blueprint for organizing data in a database system. 17. 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. 18. To simplify data storage and reduce redundancy, large tables are broken into smaller related tables. This process is called: A) Sorting. B) Data Merging. C) Normalization. D) Integrity Checking. Show Answer Correct Answer: C) Normalization. 19. How do you drop a view in SQL? A) DELETE VIEW view name;. B) REMOVE VIEW view name;. C) DROP TABLE view name;. D) DROP VIEW view name;. Show Answer Correct Answer: D) DROP VIEW view name;. 20. Which of the following is NOT a database object? A) Report. B) Graph. C) Table. D) Query. Show Answer Correct Answer: B) Graph. 21. 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. 22. ..... 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. 23. What is the purpose of a primary key in a database? A) The purpose of a primary key in a database is to uniquely identify each record in a table. B) To group related records in a table. C) To store large amounts of data efficiently. D) To enforce data integrity across multiple tables. Show Answer Correct Answer: A) The purpose of a primary key in a database is to uniquely identify each record in a table. 24. What type of data does the 'Appointments Table' in a hospital database contain? A) Patient medical history. B) Prescription details. C) Appointment ID, Patient ID, Doctor ID, Date & Time. D) Doctor specialization. Show Answer Correct Answer: C) Appointment ID, Patient ID, Doctor ID, Date & Time. 25. Which constraint uniquely identifies each row in a table? A) Unique. B) Primary Key. C) Not Null. D) Foreign Key. Show Answer Correct Answer: B) Primary Key. 26. What type of relationship involves three entities? A) Binary Relationship. B) Unary Relationship. C) Ternary Relationship. D) None of the above. Show Answer Correct Answer: C) Ternary Relationship. 27. A ..... shows specific information from a database to make it easier to read or analyze. A) View. B) Index. C) Form. D) Table. Show Answer Correct Answer: A) View. 28. Relational Structure A) A database structure that stores data in related tables using keys. B) A type of database that uses a single table for all data. C) A method of storing data in a flat file format. D) A structure that organizes data in a hierarchical manner. Show Answer Correct Answer: A) A database structure that stores data in related tables using keys. 29. How can you modify an existing table in a database? A) Use the SELECT statement. B) Use the DROP TABLE statement. C) Use the ALTER TABLE statement. D) Use the CREATE TABLE statement. Show Answer Correct Answer: C) Use the ALTER TABLE statement. 30. A relation is in this form if it is in BCNF and has no multivalued dependencies: A) Third normal form. B) Fourth normal form. C) Domain/key normal form. D) Second normal form. Show Answer Correct Answer: B) Fourth normal form. 31. Which operation is considered a query function? A) DELETE. B) INSERT. C) SELECT. D) UPDATE. Show Answer Correct Answer: C) SELECT. 32. Section A:True or False (5 marks)-Write True or False beside each statement. A database is a collection of related data that can be easily accessed and managed. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 33. Robert needs to create a database of all his friends. In a table, is what last name considered? A) Table. B) Cell Address. C) Field. D) Record. Show Answer Correct Answer: C) Field. 34. In a relational database, what is a primary table? A) A table that stores only attributes. B) A table that contains all data. C) A table that forms a relationship with another table. D) A table with no relationships. Show Answer Correct Answer: C) A table that forms a relationship with another table. 35. Apa itu konsep relasi dalam database? A) Hubungan antara entitas atau tabel dalam database yang saling terkait melalui kunci asing. B) Pengelompokan data dalam database. C) Proses penggabungan dua database. D) Hubungan antara kolom yang tidak terkait dalam database. Show Answer Correct Answer: A) Hubungan antara entitas atau tabel dalam database yang saling terkait melalui kunci asing. 36. What is the role of database designers? A) To write software programs. B) To manage hardware resources. C) To identify data to be stored. D) To monitor database usage. Show Answer Correct Answer: C) To identify data to be stored. 37. What is a lookup wizard used for? A) To create new records. B) To delete old data. C) To define lookup fields. D) To print reports. Show Answer Correct Answer: C) To define lookup fields. 38. Which of the following is NOT a valid primary key in a database? A) An order's date. B) A customer's name. C) A student's last name. D) A product's name. Show Answer Correct Answer: C) A student's last name. 39. A set of attributes in one table that refer to the primary key in another table. A) Composite key. B) Primary key. C) Unique key. D) Foreign key. Show Answer Correct Answer: D) Foreign key. 40. What does validation NOT check in a computerised system? A) Accuracy of data. B) Format of data. C) Sensibility of data. D) Reasonableness of data. Show Answer Correct Answer: A) Accuracy of data. 41. Which type of data model focuses on high-level ideas and answers the question of what a system contains? A) Logical Data Model. B) Conceptual Data Model. C) Physical Data Model. D) Relational Data Model. Show Answer Correct Answer: B) Conceptual Data Model. 42. What is the role of a database administrator (DBA)? A) To maintain a successful database environment. B) To design user interfaces. C) To create data entry forms. D) To develop new database software. Show Answer Correct Answer: A) To maintain a successful database environment. 43. What data type is used to store attachments, such as images and documents, with the records in a table? A) OLE Object. B) Attachment. C) Hyperlink. D) Calculated. Show Answer Correct Answer: B) Attachment. 44. Which of the following represents a diagram showing the logical steps of a program? A) Machine code. B) Source code. C) Debugging. D) Flowchart. Show Answer Correct Answer: D) Flowchart. 45. What is the primary performance benefit of using a stored procedure for a query that is executed thousands of times per minute? A) It automatically creates indexes on the tables being queried. B) The database caches the procedure's execution plan, avoiding the need to re-compile the query each time. C) It uses less network bandwidth because EXEC is shorter than a SELECT statement. D) It automatically runs at the SERIALIZABLE isolation level. Show Answer Correct Answer: B) The database caches the procedure's execution plan, avoiding the need to re-compile the query each time. 46. Why are databases important? A) Data Deletion, Data Corruption, Data Leakage, Data Mismanagement. B) Data Visualization, Data Encryption, Data Backup, Data Storage. C) Data Duplication, Data Obfuscation, Data Inaccessibility, Data Inefficiency. D) Data Organization, Data Integrity, Data Security, Data Analysis. Show Answer Correct Answer: D) Data Organization, Data Integrity, Data Security, Data Analysis. 47. DML is provided for A) Description of the logical structure of the database. B) Addition of new structures n the database system. C) Manipulation & processing of database. D) Definition of physical structure of the database system. Show Answer Correct Answer: C) Manipulation & processing of database. 48. What is a table in the context of databases? A) A field that uniquely identifies a record. B) A set of facts or figures arranged in a column and row structure. C) A heading for organizing data. D) A person, place, or object represented in a relational database. Show Answer Correct Answer: B) A set of facts or figures arranged in a column and row structure. 49. What is the process of identifying and correcting errors in a program called? A) Debugging. B) Documenting. C) Compiling. D) Flowcharting. Show Answer Correct Answer: A) Debugging. 50. What is the purpose of a conditional filter in a database? A) To display records that meet specific conditions. B) To format data. C) To create new fields. D) To delete data. Show Answer Correct Answer: A) To display records that meet specific conditions. 51. What is the main focus of the conceptual level in a database? A) Internal data storage details. B) Individual user view of the data. C) User interface designs. D) Community-wide data definition. Show Answer Correct Answer: D) Community-wide data definition. 52. Why is understanding database concepts essential? A) For playing computer games. B) For social media usage. C) For watching movies online. D) For effective data management and decision-making. Show Answer Correct Answer: D) For effective data management and decision-making. 53. What is the purpose of a primary key in a database table? A) To uniquely identify each row in the table. B) To categorize the data within the table. C) To store additional information about the table. D) To establish relationships between tables. Show Answer Correct Answer: A) To uniquely identify each row in the table. 54. What is the primary focus of the database management system? A) To develop applications. B) To create user interfaces. C) To maintain and organize data. D) To manage hardware. Show Answer Correct Answer: C) To maintain and organize data. 55. For some relations, modifying data can have undesirable consequences called: A) Referential integrity constraint. B) Transitive dependencies. C) Normalization form. D) Modification anomalies. Show Answer Correct Answer: D) Modification anomalies. 56. What is the best way to enter large amounts of data into a database? A) Typing it in manually. B) Printing and scanning the information. C) Using a word processor. D) Importing it from other sources. Show Answer Correct Answer: D) Importing it from other sources. 57. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with: A) A particular column in a particular underlying table. B) A particular column in a particular row. C) A particular row in a particular underlying table. D) None of the above is correct. Show Answer Correct Answer: A) A particular column in a particular underlying table. 58. What is a schema in database design? A) A column of data in a table. B) The overall logical structure of a database. C) A security password. D) A user's record. Show Answer Correct Answer: B) The overall logical structure of a database. 59. Which MongoDB command is used to display all databases? A) Db.showDatabases(). B) Show collections. C) Show dbs. D) Db.getCollectionNames(). Show Answer Correct Answer: C) Show dbs. 60. Different relation classes created by techniques to prevent modification anomalies are called: A) Normalization forms. B) Referential integrity constraints. C) Functional dependencies. D) None of the above. Show Answer Correct Answer: A) Normalization forms. ← PreviousNext →Related QuizzesScience QuizzesClass 11 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books