This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 9 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 9 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. RDBMS stands for A) Relational database system. B) Relational database management system. C) Relational management system. D) None of these. Show Answer Correct Answer: B) Relational database management system. 2. An insertion anomaly happens when: A) Inserting redundant data occurs. B) A foreign key is missing. C) A table does not have a primary key. D) A table has too many relationships. Show Answer Correct Answer: A) Inserting redundant data occurs. 3. To be in 1NF: A) Each field contains the smallest meaningful value. B) There are multiple values in the single field. C) There are no duplicate records. D) A primary key is assigned. Show Answer Correct Answer: A) Each field contains the smallest meaningful value. 4. Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a: A) Data dictionary. B) Database management system (DBMS). C) Decision support system. D) Relational database. Show Answer Correct Answer: B) Database management system (DBMS). 5. Write a SQL query to retrieve the unique records from a table named 'products'. A) SELECT DISTINCT * FROM products;. B) GET UNIQUE FROM products. C) RETRIEVE UNIQUE FROM products. D) SELECT UNIQUE products. Show Answer Correct Answer: A) SELECT DISTINCT * FROM products;. 6. The select operation in a database: A) Combines relational tables. B) Creates a subset consisting of all records that meet stated criteria. C) Creates a subset consisting of columns in a table. D) Identifies the table from which columns will be selected. Show Answer Correct Answer: B) Creates a subset consisting of all records that meet stated criteria. 7. Which common database challenge is illustrated by Sally receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of her full name? A) Data normalization. B) Data accuracy. C) Data redundancy. D) Data inconsistency. Show Answer Correct Answer: C) Data redundancy. 8. What role do entities play in a relational database? A) Entities serve as the primary building blocks in a relational database, defining the structure and relationships of the data. B) Entities are only used for data storage. C) Entities are irrelevant in defining relationships. D) Entities are solely responsible for data retrieval. Show Answer Correct Answer: A) Entities serve as the primary building blocks in a relational database, defining the structure and relationships of the data. 9. Which ACID property would be violated if a transaction writes data that is lost when the system crashes? A) Atomicity. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: A) Atomicity. 10. A ..... represents data as two-dimensional tables. A) Non-relational DBMS. B) Mobile DBMS. C) Relational DBMS. D) Hierarchical DBMS. Show Answer Correct Answer: C) Relational DBMS. 11. ..... is the one who manages the complex database management system. A) GIS. B) GPS. C) DBA. D) BAD. Show Answer Correct Answer: C) DBA. 12. What is the conceptual level in the ANSI three-level architecture? A) The universal view of the database. B) The physical storage of data. C) The user interface for the database. D) The programming interface for the database. Show Answer Correct Answer: A) The universal view of the database. 13. What is the first step in the normalization process? A) Convert to first normal form. B) Create an E-R diagram. C) Identify the primary key. D) Convert to third normal form. Show Answer Correct Answer: A) Convert to first normal form. 14. How can you filter records in a database? A) Using a query with specific conditions. B) Creating a new table. C) Deleting unwanted records. D) Changing the database format. Show Answer Correct Answer: A) Using a query with specific conditions. 15. How would you retrieve the "name" and "email" columns from a table named "users" ? A) GET name, email FROM users;. B) SELECT name, email FROM users;. C) RETRIEVE name, email FROM users;. D) SHOW name, email FROM users;. Show Answer Correct Answer: B) SELECT name, email FROM users;. 16. What does data redundancy refer to? A) The standardization of data formats. B) The process of securing data. C) Duplication of data within a database. D) The ability to share data among users. Show Answer Correct Answer: C) Duplication of data within a database. 17. Which PL/SQL object stores reusable SQL blocks without returning a value? A) Function. B) Procedure. C) Trigger. D) Cursor. Show Answer Correct Answer: B) Procedure. 18. What is a "query" in the context of relational databases? A) A table used to store data. B) A request for data or information from a database. C) A way to define relationships between tables. D) A command that joins two databases. Show Answer Correct Answer: B) A request for data or information from a database. 19. What does concurrency in data sharing refer to? A) The ability to access data sequentially. B) The ability to execute multiple transactions simultaneously. C) The ability to delete data quickly. D) The ability to store data in multiple locations. Show Answer Correct Answer: B) The ability to execute multiple transactions simultaneously. 20. What is the primary purpose of a database management system (DBMS)? A) To create physical copies of data. B) To manage and organize data within a database. C) To delete data permanently. D) To convert data into images. Show Answer Correct Answer: B) To manage and organize data within a database. 21. Cascading aborts occur when: A) One rollback causes others to rollback. B) Transactions run serially. C) All commit successfully. D) Deadlock occurs. Show Answer Correct Answer: A) One rollback causes others to rollback. 22. Which one of the following attributes cannot be taken as a primary key? A) ID. B) RegistrationNo. C) DepartmentID. D) Street. Show Answer Correct Answer: D) Street. 23. Which data model represents entities and their relationships? A) Flat File Model. B) Network Model. C) ER Model (Entity Relationship). D) Tabular Model. Show Answer Correct Answer: C) ER Model (Entity Relationship). 24. What does the term 'referential integrity' mean in database relationships? A) A field must contain only numbers. B) A foreign key value must match a primary key in another table. C) A database cannot contain more than two tables. D) Data in a query cannot be updated. Show Answer Correct Answer: B) A foreign key value must match a primary key in another table. 25. Many users access many servers. Why is this statement not a good inclusion in an ER diagram? A) It creates duplicates and therefore redundancy. B) It is not a good idea to access too many servers. C) It is syntactically incorrect. D) It involves a bridging entity. Show Answer Correct Answer: A) It creates duplicates and therefore redundancy. ← 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 10Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books