This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 27 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 27 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is an association among several entities? A) Entity. B) Relationship. C) All the above. D) None of the above. Show Answer Correct Answer: B) Relationship. 2. What is the primary limitation of a file-based approach to data storage? A) High cost. B) Limited storage capacity. C) Inefficient data management and potential redundancy. D) Complexity of implementation. Show Answer Correct Answer: C) Inefficient data management and potential redundancy. 3. Which of the following is a type of DBMS? A) Relational B) Linear C) Circular D) Random A) A) Relational. B) NoSQL. C) Object-oriented. D) Graph. Show Answer Correct Answer: A) A) Relational. 4. What are the three main types of DBMS? A) Hierarchical DBMS, Network DBMS, Relational DBMS. B) Columnar DBMS. C) Object-oriented DBMS. D) Document DBMS. Show Answer Correct Answer: A) Hierarchical DBMS, Network DBMS, Relational DBMS. 5. What is the purpose of a data dictionary in a database? A) To store user passwords. B) To define the structure of the database. C) To manage database backups. D) To execute SQL queries. Show Answer Correct Answer: B) To define the structure of the database. 6. Backup:A copy of the database stored ..... ? A) Separately. B) Together with the original. C) In the same file. D) Without any location. Show Answer Correct Answer: A) Separately. 7. Google Chrome uses which DBMS to store local browser data? A) MySQL. B) SQLite. C) Redis. D) PostgreSQL. Show Answer Correct Answer: B) SQLite. 8. Which of the following best describes a document store? A) A database that only supports key-value pairs without structure. B) A type of file system used for storing images and videos. C) A database that stores data in documents, typically in JSON or BSON format. D) A database that stores data in tables with rows and columns. Show Answer Correct Answer: C) A database that stores data in documents, typically in JSON or BSON format. 9. Which of the following is a characteristic of a Relational Database Management System? A) Data is stored in files with no defined structure. B) It uses a hierarchical model with a parent-child relationship. C) Data is organized into tables (relations) with rows and columns. D) It does not support complex queries or data manipulation. Show Answer Correct Answer: C) Data is organized into tables (relations) with rows and columns. 10. What is meant by 'instance' in the context of databases? A) The metadata of a database. B) A specific occurrence of data in the database. C) The logical view of data. D) The software used to manage databases. Show Answer Correct Answer: B) A specific occurrence of data in the database. 11. What should foreign key constraints in databases include according to the image? A) A simple name related to the table. B) A composite name identifying tables and functionality. C) Only the primary key of the parent table. D) Numerals to distinguish different foreign keys. Show Answer Correct Answer: B) A composite name identifying tables and functionality. 12. What term is used to describe the users who interact with the database without directly dealing with its internal structure? A) Database Administrators. B) End Users. C) Developers. D) System Analysts. Show Answer Correct Answer: B) End Users. 13. What does the acronym SQL stand for? A) Structured Query Language. B) Standard Query Language. C) Structured Query List. D) Simple Query Language. Show Answer Correct Answer: A) Structured Query Language. 14. A relational database developer refers to a record as ..... A) Domain. B) Relation. C) Tuple. D) Attribute. Show Answer Correct Answer: C) Tuple. 15. Which of the following is an example of a centralized database? A) Personal computer databases used in small businesses. B) Websites providing large file downloads. C) Distributed databases replicated to various sites. D) Data warehouses for archival data. Show Answer Correct Answer: A) Personal computer databases used in small businesses. 16. Which clause is used to rename a column or table in a query result? A) ALIAS. B) RENAME. C) AS. D) CHANGE. Show Answer Correct Answer: C) AS. 17. What is the purpose of the HAVING clause? A) To sort data. B) To filter groups. C) To create views. D) To join tables. Show Answer Correct Answer: B) To filter groups. 18. What is the primary use of data modeling in a DBMS? A) To create visually appealing database diagrams. B) To identify and define relationships between data entities. C) To optimize database performance. D) To generate automated test cases. Show Answer Correct Answer: B) To identify and define relationships between data entities. 19. What is the purpose of the LIMIT clause in SQL? A) To sort the result set in descending order. B) To join multiple tables together. C) To restrict the number of records returned by a query. D) To filter records based on specified conditions. Show Answer Correct Answer: C) To restrict the number of records returned by a query. 20. Based on the structure of the document, what is likely discussed under "Problems with Traditional Files Systems Approach" ? A) Limitations of storing data in traditional file systems. B) How to create a website. C) The history of programming languages. D) The basics of computer hardware. Show Answer Correct Answer: A) Limitations of storing data in traditional file systems. 21. What is a risk associated with a single point of failure? A) File format inconsistencies. B) Server downtime. C) Data redundancy. D) User access issues. Show Answer Correct Answer: B) Server downtime. 22. Which normal form eliminates partial dependency? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) Boyce-Codd Normal Form (BCNF). Show Answer Correct Answer: B) Second Normal Form (2NF). 23. What is the importance of normalization in database design? A) Normalization increases data redundancy. B) Normalization is only necessary for large databases. C) Normalization complicates data management. D) Normalization is important in database design because it reduces data redundancy, improves data integrity, and simplifies data management. Show Answer Correct Answer: D) Normalization is important in database design because it reduces data redundancy, improves data integrity, and simplifies data management. 24. Which database model uses tables? A) Hierarchical. B) Network. C) Relational. D) Object-oriented. Show Answer Correct Answer: C) Relational. 25. Which of the following is a limitation of a file system? A) Data redundancy. B) Data encryption. C) Data normalization. D) Data visualization. Show Answer Correct Answer: A) Data redundancy. ← 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