This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 11 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which DBMS model supports many-to-many relationships using a graph structure? A) Hierarchical. B) Network. C) Relational. D) Flat File. Show Answer Correct Answer: B) Network. 2. How can a hospital's database management system improve patient care efficiency? A) Allowing patients to edit their own medical records. B) Eliminating the need for healthcare professionals. C) Providing real-time access to patient data for healthcare professionals. D) Storing data in unencrypted formats. Show Answer Correct Answer: C) Providing real-time access to patient data for healthcare professionals. 3. Which of the following is a type of Relational Database Management System (RDBMS)? A) Oracle Database. B) Neo4j. C) Redis. D) MongoDB. Show Answer Correct Answer: A) Oracle Database. 4. What is the purpose of DDL in SQL? A) To enhance performance. B) To manipulate data. C) To define data structures. D) To create backups. Show Answer Correct Answer: C) To define data structures. 5. Which of the following command is a type of Data Definition language command? A) Merge. B) Update. C) Delete. D) Create. Show Answer Correct Answer: D) Create. 6. What is the role of transaction management in a database system? A) Manage user authentication. B) Ensure data consistency and integrity. C) Design database tables. D) Optimize query performance. Show Answer Correct Answer: B) Ensure data consistency and integrity. 7. The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 8. Isolation:The effects of a transaction are not visible to other transactions until it ..... A) Commits. B) Aborts. C) Rolls back. D) Starts. Show Answer Correct Answer: A) Commits. 9. An association of various entities in an Entity-Relation model is known as A) Record. B) Tuple. C) Field. D) Relationship. Show Answer Correct Answer: D) Relationship. 10. In-memory databases are used for long-term data storage. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 11. The ..... rule states that an entity instance can simultaneously be a member of two (or more) subtypes. A) Partial specialization. B) Total specialization. C) Disjoint. D) Overlap. Show Answer Correct Answer: D) Overlap. 12. In a database transaction, what does the acronym ACID stand for? A) Atomicity, Concurrency, Isolation, Dependability. B) Atomicity, Consistency, Isolation, Durability. C) Accuracy, Concurrency, Integrity, Dependability. D) Accuracy, Consistency, Integrity, Durability. Show Answer Correct Answer: B) Atomicity, Consistency, Isolation, Durability. 13. What is SQL and how is it used in DBMS? A) SQL is a programming language used to manage and manipulate relational databases in a DBMS. B) SQL is a type of hardware used for data storage. C) SQL is a markup language for web development. D) SQL is a database management system itself. Show Answer Correct Answer: A) SQL is a programming language used to manage and manipulate relational databases in a DBMS. 14. In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 15. What is a database model? A) A database model is a type of software used for data analysis. B) A database model is a framework for organizing and defining the structure of data in a database. C) A database model is a method for securing data against unauthorized access. D) A database model is a programming language for creating applications. Show Answer Correct Answer: B) A database model is a framework for organizing and defining the structure of data in a database. 16. What is a subquery? A) A subquery is a command to delete records from a table. B) A subquery is a type of database index. C) A subquery is a function that aggregates data from multiple tables. D) A subquery is a nested query within another SQL query. Show Answer Correct Answer: D) A subquery is a nested query within another SQL query. 17. Which of the following is a completeness constraint? A) Total specialization. B) Partial generalization. C) Total recall. D) Partial hybridization. Show Answer Correct Answer: A) Total specialization. 18. What is a common use case for a Relational Database? A) Managing customer information in a business. B) Storing large video files for streaming. C) Tracking employee attendance records. D) Managing social media posts and interactions. Show Answer Correct Answer: A) Managing customer information in a business. 19. ..... :A database spread across multiple locations. A) Distributed Database. B) Relational Database. C) Hierarchical Database. D) Centralized Database. Show Answer Correct Answer: A) Distributed Database. 20. ..... :Software that manages communication between client and server. A) Spreadsheet. B) Middleware. C) Compiler. D) Debugger. Show Answer Correct Answer: B) Middleware. 21. What is a characteristic of a hierarchical database? A) Many-to-many relationships. B) No relationships. C) One-to-many relationships. D) Flat structure. Show Answer Correct Answer: C) One-to-many relationships. 22. What uses a collection of tables to represent both data and relationships among the data? A) Relational model. B) Entity-Relationship data model. C) Object-based data models. D) None of the above. Show Answer Correct Answer: A) Relational model. 23. What is the purpose of SQL? A) To create diagrams. B) To design websites. C) To write reports. D) To manage databases. Show Answer Correct Answer: D) To manage databases. 24. 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. 25. Which of the following is a type of DBMS? A) Relational B) Linear C) Circular D) Random A) A) Relational. B) Object-oriented. C) NoSQL. D) Graph. Show Answer Correct Answer: A) A) Relational. 26. What are the three main types of DBMS? A) Hierarchical DBMS, Network DBMS, Relational DBMS. B) Object-oriented DBMS. C) Columnar DBMS. D) Document DBMS. Show Answer Correct Answer: A) Hierarchical DBMS, Network DBMS, Relational DBMS. 27. What is the purpose of a data dictionary in a database? A) To store user passwords. B) To execute SQL queries. C) To define the structure of the database. D) To manage database backups. Show Answer Correct Answer: C) To define the structure of the database. 28. Backup:A copy of the database stored ..... ? A) Separately. B) Without any location. C) In the same file. D) Together with the original. Show Answer Correct Answer: A) Separately. 29. Google Chrome uses which DBMS to store local browser data? A) MySQL. B) PostgreSQL. C) SQLite. D) Redis. Show Answer Correct Answer: C) SQLite. 30. 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. 31. 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. 32. 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 software used to manage databases. D) The logical view of data. Show Answer Correct Answer: B) A specific occurrence of data in the database. 33. 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. 34. What term is used to describe the users who interact with the database without directly dealing with its internal structure? A) System Analysts. B) Developers. C) Database Administrators. D) End Users. Show Answer Correct Answer: D) End Users. 35. 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. 36. A relational database developer refers to a record as ..... A) Relation. B) Tuple. C) Domain. D) Attribute. Show Answer Correct Answer: B) Tuple. 37. 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. 38. 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. 39. What is the purpose of the HAVING clause? A) To sort data. B) To filter groups. C) To join tables. D) To create views. Show Answer Correct Answer: B) To filter groups. 40. 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. 41. What is the purpose of the LIMIT clause in SQL? A) To restrict the number of records returned by a query. B) To sort the result set in descending order. C) To filter records based on specified conditions. D) To join multiple tables together. Show Answer Correct Answer: A) To restrict the number of records returned by a query. 42. Based on the structure of the document, what is likely discussed under "Problems with Traditional Files Systems Approach" ? A) The history of programming languages. B) How to create a website. C) The basics of computer hardware. D) Limitations of storing data in traditional file systems. Show Answer Correct Answer: D) Limitations of storing data in traditional file systems. 43. What is a risk associated with a single point of failure? A) User access issues. B) Server downtime. C) Data redundancy. D) File format inconsistencies. Show Answer Correct Answer: B) Server downtime. 44. 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. 45. Which database model uses tables? A) Hierarchical. B) Relational. C) Object-oriented. D) Network. Show Answer Correct Answer: B) Relational. 46. Which of the following is a limitation of a file system? A) Data normalization. B) Data visualization. C) Data redundancy. D) Data encryption. Show Answer Correct Answer: C) Data redundancy. 47. A company decides to migrate its data from a file-processing system to a DBMS. What is the most significant challenge they will face? A) Finding enough storage space for the data. B) Managing the small increase in data redundancy. C) Converting existing applications to interact with the new DBMS. D) The lack of security features in a DBMS. Show Answer Correct Answer: C) Converting existing applications to interact with the new DBMS. 48. What are some common database security measures? A) User training programs. B) Data backups. C) Performance monitoring. D) Access controls, encryption, regular updates, security audits, firewalls. Show Answer Correct Answer: D) Access controls, encryption, regular updates, security audits, firewalls. 49. Database can be define as ..... A) An integrated collection of related data. B) Unprocessed items. C) Rows and columns that make up a table. D) Related data that has been categorized in to specific fields. Show Answer Correct Answer: A) An integrated collection of related data. 50. A centralized database architecture means: A) Data is stored on the cloud. B) Data resides in a single location. C) Data is distributed among multiple servers. D) Data is replicated across servers. Show Answer Correct Answer: B) Data resides in a single location. 51. Identify the spatial index structure that is effective for indexing data in multi-dimensional spaces A) R-tree. B) Quadtree. C) Kd-tree. D) Grid file. Show Answer Correct Answer: A) R-tree. 52. Which technique prevents invalid data being saved in Access table? A) Filter. B) Input mark. C) Index. D) Validation rule. Show Answer Correct Answer: D) Validation rule. 53. "Delete from Student;"The above command performs which of the following action? A) Removes constraints from the table. B) Removes fields/columns from the table. C) Removes tuples from the table. D) Removes table from database. Show Answer Correct Answer: C) Removes tuples from the table. 54. How does the three-tier schema architecture promote data independence? A) It requires all levels to be changed simultaneously. B) The three-tier schema architecture promotes data independence by allowing changes at one level without affecting the others. C) It enforces a single schema for all data access. D) It eliminates the need for a database entirely. Show Answer Correct Answer: B) The three-tier schema architecture promotes data independence by allowing changes at one level without affecting the others. 55. What is the actual content of the database at a particular point in time called? A) Instance. B) Schema. C) Data Model. D) None of the above. Show Answer Correct Answer: A) Instance. 56. Which factor determines whether a database is classified as single-user or multiuser? A) The amount of data stored. B) The type of operating system used. C) The speed of the computer. D) The number of users. Show Answer Correct Answer: D) The number of users. 57. A scout company have a database with records of all the scouts. They want to create a list of all scouts who are under 15 and their achievements. What would they use? A) Report. B) Query. C) Sort. D) Form. Show Answer Correct Answer: B) Query. 58. It is the use sophisticated statistical analysis, including artificial intelligence techniques such as neural networks, to "discover" unhypothesized relationships in the data. For example, credit card companies use this to identify usage patterns indicative of fraud. A) Database system. B) Data integration. C) Data Sharing. D) Data Mining. Show Answer Correct Answer: D) Data Mining. 59. Which property ensures data consistency in a database? A) Isolation. B) Availability. C) Consistency. D) Durability. Show Answer Correct Answer: C) Consistency. 60. Which of the following best describes a database schema? A) The overall design of the database. B) The current data in the database. C) The user interface of the database. D) The security settings of the database. Show Answer Correct Answer: A) The overall design of the database. ← PreviousNext →Related QuizzesScience QuizzesClass 12 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books