This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 46 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 46 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a major disadvantage of a file-based system compared to a DBMS? A) Data redundancy and inconsistency. B) Easier access control. C) Faster data retrieval. D) Better concurrency handling. Show Answer Correct Answer: A) Data redundancy and inconsistency. 2. CREATE TABLE employee (name VARCHAR, id INTEGER)What type of statement is this? A) DDL. B) DML. C) DCL. D) TCL. Show Answer Correct Answer: A) DDL. 3. What is the main focus of a database designer? A) Writing application code. B) Performing data entry. C) Managing user access. D) Designing the database structure. Show Answer Correct Answer: D) Designing the database structure. 4. What is the primary role of a Data Manipulation Language (DML) in a database? A) Defining database structure. B) Manipulating and querying database. C) Ensuring data security. D) Managing user permissions. Show Answer Correct Answer: B) Manipulating and querying database. 5. Which of the following would NOT use big data analysis? A) Healthcare companies. B) Public agencies. C) Retail companies. D) High school students doing homework. Show Answer Correct Answer: D) High school students doing homework. 6. What is a flat file? A) A file with videos. B) A file with multiple tables. C) A file with no relations. D) A file with images. Show Answer Correct Answer: C) A file with no relations. 7. What is the primary goal of data storage in a database system? A) Minimize data redundancy. B) Maximize data security. C) Minimize query performance. D) Maximize data entry speed. Show Answer Correct Answer: A) Minimize data redundancy. 8. What is the core part of an operating system that directly interacts with hardware? A) Shell. B) Kernel. C) GUI. D) API. Show Answer Correct Answer: B) Kernel. 9. What does the term 'aggregation' mean in ER modeling? A) Creating new entities. B) Linking relationships. C) Grouping attributes. D) Combining data. Show Answer Correct Answer: D) Combining data. 10. Which of the following is a use of DBMS in agriculture? A) Monitoring crop growth and yields. B) Predicting pest infestation trends. C) Managing irrigation schedules. D) All of the above. Show Answer Correct Answer: D) All of the above. 11. What is an access right in a DBMS? A) A permission level assigned to users or groups. B) A function that deletes old records. C) A setting that forces users to use SQL. D) A tool that automatically modifies database schemas. Show Answer Correct Answer: A) A permission level assigned to users or groups. 12. How can query execution plans help in optimizing SQL queries? A) They automatically rewrite SQL queries for better performance. B) Query execution plans help in optimizing SQL queries by revealing inefficiencies and guiding improvements. C) They provide a graphical representation of the database schema. D) They eliminate the need for indexing in databases. Show Answer Correct Answer: B) Query execution plans help in optimizing SQL queries by revealing inefficiencies and guiding improvements. 13. What is a rollback in transaction management? A) A rollback is a process that saves changes made during a transaction. B) A rollback is a technique to create new transactions. C) A rollback is a process that undoes changes made during a transaction. D) A rollback is a method to permanently apply changes in a database. Show Answer Correct Answer: C) A rollback is a process that undoes changes made during a transaction. 14. Define ACID properties in transaction management. A) Atomicity, Consistency, Isolation, Validity. B) Accuracy, Clarity, Integrity, Reliability. C) ACID properties:Atomicity, Consistency, Isolation, Durability. D) Atomicity, Concurrency, Isolation, Durability. Show Answer Correct Answer: C) ACID properties:Atomicity, Consistency, Isolation, Durability. 15. A lock that allows concurrent transactions to access different rows of the same table is known as a A) Database-level lock. B) Table-level lock. C) Page-level lock. D) Row-level lock. Show Answer Correct Answer: D) Row-level lock. 16. What is the benefit of using NoSQL databases? A) NoSQL databases are less efficient than traditional SQL databases. B) NoSQL databases are only suitable for small datasets. C) NoSQL databases require a fixed schema for data storage. D) The benefit of using NoSQL databases includes flexibility, scalability, and the ability to handle large volumes of unstructured data. Show Answer Correct Answer: D) The benefit of using NoSQL databases includes flexibility, scalability, and the ability to handle large volumes of unstructured data. 17. What is the difference between a weak entity and a strong entity? A) A strong entity is always dependent on a weak entity for its existence. B) Both weak and strong entities have the same characteristics and can be used interchangeably. C) A weak entity depends on a strong entity for its existence and lacks a primary key, whereas a strong entity can exist independently and has a primary key. D) A weak entity has a primary key and can exist independently. Show Answer Correct Answer: C) A weak entity depends on a strong entity for its existence and lacks a primary key, whereas a strong entity can exist independently and has a primary key. 18. What is a key feature of a database? A) It cannot store multimedia data. B) It can only be accessed by one user. C) It is designed for a specific purpose. D) It is always small in size. Show Answer Correct Answer: C) It is designed for a specific purpose. 19. What is a data model and why is it important? A) A data model is irrelevant for data analysis and reporting. B) A data model is a conceptual framework for organizing and defining data structures and relationships, crucial for effective data management and communication. C) A data model is only used for programming languages. D) A data model is a physical representation of data storage devices. Show Answer Correct Answer: B) A data model is a conceptual framework for organizing and defining data structures and relationships, crucial for effective data management and communication. 20. Variety is a characteristic of big data. Which type of formats does Variety comes from? A) Structured. B) Unstructured. C) Semi-structured. D) All of the above. Show Answer Correct Answer: D) All of the above. 21. What is the main advantage of using a relational database? A) Faster data entry. B) Improved data security. C) Reduced data redundancy. D) Easier data visualization. Show Answer Correct Answer: C) Reduced data redundancy. 22. What SQL clause is used to restrict the rows returned by a query? A) WHEN. B) HAVING. C) FROM. D) WHERE. Show Answer Correct Answer: D) WHERE. 23. Which of the following is a function of a DBMS that ensures the integrity and consistency of data? A) Data dictionary management. B) Network configuration. C) Hardware maintenance. D) User interface design. Show Answer Correct Answer: A) Data dictionary management. 24. In a relational database, a foreign key must be unique. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 25. Database if the collection of information or group of facts in a structured way. A) Maybe. B) No. C) Yes. D) Not Always. Show Answer Correct Answer: C) Yes. ← 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