This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 12 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 12 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The process of structuring data to reduce redundancy is called: A) Optimization. B) Normalization. C) Aggregation. D) Transformation. Show Answer Correct Answer: B) Normalization. 2. Which DBMS is used by NASA for analyzing complex data relationships? A) Neo4j. B) Redis. C) InfluxDB. D) Couchbase. Show Answer Correct Answer: A) Neo4j. 3. Identify the spatial data type that is used to represent a continuous surface, such as temperature or elevation? A) Point. B) LineString. C) Polygon. D) Raster. Show Answer Correct Answer: D) Raster. 4. In the relational model, a row is also known as a: A) Attribute. B) Tuple. C) Field. D) Key. Show Answer Correct Answer: B) Tuple. 5. What is a Database Management System (DBMS)? A) Software for managing databases B) A type of hardware C) A programming language D) A network protocol A) A web browser. B) A cloud storage service. C) A) Software for managing databases. D) A type of operating system. Show Answer Correct Answer: C) A) Software for managing databases. 6. In which of the following formats data is stored in the database management system? A) Table. B) Image. C) Text. D) Graph. Show Answer Correct Answer: A) Table. 7. Which database language is used for defining and manipulating the structure of the database? A) SQL. B) Java. C) C++. D) Python. Show Answer Correct Answer: A) SQL. 8. Why is encapsulation important in object-oriented programming? A) It hides implementation details and only exposes necessary data through methods. B) It allows methods from different classes to be accessed directly. C) It prevents the use of multiple classes in a single program. D) It forces all classes to have only public variables. Show Answer Correct Answer: A) It hides implementation details and only exposes necessary data through methods. 9. What does 'data independence' mean? A) Data is stored in multiple locations. B) Applications are insulated from how data is structured. C) Data can be accessed by anyone. D) Data is always encrypted. Show Answer Correct Answer: B) Applications are insulated from how data is structured. 10. Which of the following describes a one-to-many relationship? A) One entity is associated with one entity. B) No entities are associated. C) One entity is associated with multiple entities. D) Multiple entities are associated with one entity. Show Answer Correct Answer: C) One entity is associated with multiple entities. 11. In a remote transaction, each SQL statement can reference data from multiple remote sites. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 12. How does indexing improve database performance? A) Indexing slows down data retrieval by adding extra steps. B) Indexing increases the amount of data stored in the database. C) Indexing has no effect on search time or performance. D) Indexing enhances database performance by speeding up data retrieval and reducing search time. Show Answer Correct Answer: D) Indexing enhances database performance by speeding up data retrieval and reducing search time. 13. Dirty Read (Uncommitted Dependency):Reading data written by a transaction that has not ..... A) Committed. B) Rolled back. C) Locked. D) Executed. Show Answer Correct Answer: A) Committed. 14. Define metadata? A) Recorded facts. B) Interrelated data. C) Software that manages and control data. D) Data that describes other data. Show Answer Correct Answer: D) Data that describes other data. 15. Name three types of DBMS. A) Hierarchical DBMS, Network DBMS, Relational DBMS. B) Object-oriented DBMS. C) Multidimensional DBMS. D) Distributed DBMS. Show Answer Correct Answer: A) Hierarchical DBMS, Network DBMS, Relational DBMS. 16. What type of data independence is the ability to modify the physical or internal schema without changing the logical or external schemas? A) Physical Data Independence. B) Logical Data Independence. C) All the above. D) None of the above. Show Answer Correct Answer: A) Physical Data Independence. 17. Explain the concept of a data dictionary in a DBMS. A) A data dictionary only contains user data without any metadata. B) A data dictionary is a type of database management software. C) A data dictionary is a repository of metadata that describes the structure, relationships, and constraints of data in a database. D) A data dictionary is used solely for data backup purposes. Show Answer Correct Answer: C) A data dictionary is a repository of metadata that describes the structure, relationships, and constraints of data in a database. 18. What does SQL stand for in database management systems? A) Structured Query Language. B) Simple Query Language. C) Sequential Query Language. D) Standard Query Language. Show Answer Correct Answer: A) Structured Query Language. 19. Describe the ACID properties of transactions. A) Atomicity, Concurrency, Isolation, Stability. B) Accuracy, Clarity, Integrity, Reliability. C) Atomicity, Consistency, Isolation, Availability. D) ACID properties:Atomicity, Consistency, Isolation, Durability. Show Answer Correct Answer: D) ACID properties:Atomicity, Consistency, Isolation, Durability. 20. Rollback:Undoing changes made by ..... transactions. A) Uncommitted. B) Committed. C) Active. D) Failed. Show Answer Correct Answer: A) Uncommitted. 21. What are the primary responsibilities of a Database Administrator (DBA)? A) The primary responsibilities of a Database Administrator (DBA) include database management, performance tuning, backup and recovery, security management, and policy implementation. B) Data entry and customer support. C) Network administration and hardware maintenance. D) Software development and coding. Show Answer Correct Answer: A) The primary responsibilities of a Database Administrator (DBA) include database management, performance tuning, backup and recovery, security management, and policy implementation. 22. The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 23. A company is experiencing frequent errors due to inconsistent data across departments. Which of the following DBMS advantages would best address this issue? A) Improved decision making. B) Minimized data inconsistency. C) Increased end-user productivity. D) Improved data sharing. Show Answer Correct Answer: B) Minimized data inconsistency. 24. Which of the following best describes the challenge of "Maintaining Currency" in DBMS? A) Keeping the DBMS updated with the latest technology and standards. B) Ensuring the database is free from errors. C) Reducing the cost of database management. D) Increasing vendor independence. Show Answer Correct Answer: A) Keeping the DBMS updated with the latest technology and standards. 25. If a database system frequently experiences deadlocks, which of the following would be the best approach to handle the issue? A) Implementing deadlock detection and resolution. B) Removing all foreign key constraints. C) Avoiding the use of ACID properties. D) Increasing the database cache size. Show Answer Correct Answer: A) Implementing deadlock detection and resolution. ← PreviousNext →Related QuizzesClass 12 Computer Science Chapter 3 Database Management Systems Quiz 1Class 12 Computer Science Chapter 3 Database Management Systems Quiz 2Class 12 Computer Science Chapter 3 Database Management Systems Quiz 3Class 12 Computer Science Chapter 3 Database Management Systems Quiz 4Class 12 Computer Science Chapter 3 Database Management Systems Quiz 5Class 12 Computer Science Chapter 3 Database Management Systems Quiz 6Class 12 Computer Science Chapter 3 Database Management Systems Quiz 7Class 12 Computer Science Chapter 3 Database Management Systems Quiz 8Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books