This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 6 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 6 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What are the common types of failures in database systems? A) Database upgrades. B) Common types of failures in database systems include hardware failures, software bugs, human errors, network issues, and data corruption. C) Increased storage capacity. D) Power outages. Show Answer Correct Answer: B) Common types of failures in database systems include hardware failures, software bugs, human errors, network issues, and data corruption. 2. Using a packaged data model, projects take less time and cost because: A) Less personnel are required. B) Essential components and structures are already defined. C) There is more time taken to model the enterprise. D) Packaged data models only run in Oracle. Show Answer Correct Answer: B) Essential components and structures are already defined. 3. Which SQL clause groups rows sharing a property so that an aggregate function can be applied to each group? A) ORDER BY. B) HAVING. C) FILTER BY. D) GROUP BY. Show Answer Correct Answer: D) GROUP BY. 4. In a database, Multiple ..... can be created. A) Tables. B) Documents. C) Primary Key. D) All of these. Show Answer Correct Answer: A) Tables. 5. The database acts as the ..... of an information system. A) User interface. B) Output device. C) Central repository. D) Network controller. Show Answer Correct Answer: C) Central repository. 6. What is a collection of similar entities called? A) Entity Collection. B) Entity Class. C) Entity Set. D) Entity Group. Show Answer Correct Answer: C) Entity Set. 7. What does a schema with constraints enforce? A) User access levels. B) Data redundancy. C) File storage. D) Common formats. Show Answer Correct Answer: D) Common formats. 8. Which of the following is NOT an application of DBMS? A) Library Management System. B) Railway Reservation System. C) Web Browsing. D) Banking System. Show Answer Correct Answer: C) Web Browsing. 9. Which type of partitioning distributes the rows of a table into separate tables based on a key range? A) Hash Partitioning. B) Vertical Partitioning. C) Composite Partitioning. D) Horizontal Partitioning. Show Answer Correct Answer: B) Vertical Partitioning. 10. Which combination of key zooms the content of active cell in Access table? A) Shift + F2. B) Ctrl + F5. C) Shift + F5. D) Ctrl + F2. Show Answer Correct Answer: A) Shift + F2. 11. Which of the following is NOT example of data? A) The boy received RM10. B) The. C) RM10. D) Boy. Show Answer Correct Answer: A) The boy received RM10. 12. Data Integrity means that data is accurate and consistent in the database.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: A) A. True. 13. What is the most common classification applied to a DBMS? A) Number of users. B) Database site location(s). C) Expected type and extent of use. D) Software manufacturer. Show Answer Correct Answer: C) Expected type and extent of use. 14. What does a Database Management System (DBMS) do? A) Creates user interfaces. B) Only stores data. C) Performs data analysis. D) Interacts with and manages data in the database. Show Answer Correct Answer: D) Interacts with and manages data in the database. 15. A/an ..... is a database that is created and maintained using cloud data services, such as Microsoft Azure or Amazon AWS. A) Cloud database. B) Unstructure database. C) Centralized database. D) Data warehouse. Show Answer Correct Answer: A) Cloud database. 16. A database developer decides to add an index to the 'zip code' column in a large 'customers' table. What is the primary reason for this action? A) To increase the total amount of data stored in the database. B) To improve the performance of queries that search for customers in a specific zip code. C) To enforce a unique constraint on the zip code values. D) To prevent unauthorized users from viewing the data. Show Answer Correct Answer: B) To improve the performance of queries that search for customers in a specific zip code. 17. Explain the first normal form (1NF). A) First Normal Form (1NF) allows duplicate values in columns. B) 1NF requires that all data types in a column be the same. C) First Normal Form (1NF) is only applicable to relational databases. D) First Normal Form (1NF) is a property of a relation in a database that ensures all columns contain atomic values and each column has a unique name. Show Answer Correct Answer: D) First Normal Form (1NF) is a property of a relation in a database that ensures all columns contain atomic values and each column has a unique name. 18. Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 19. What is the role of the data dictionary in a DBMS? A) To print reports. B) To process user queries. C) To store actual data records. D) To store metadata about the structure of the database. Show Answer Correct Answer: D) To store metadata about the structure of the database. 20. Which SQL statement is used to update existing data in a table? A) UPDATE. B) MODIFY. C) CHANGE. D) ALTER. Show Answer Correct Answer: A) UPDATE. 21. Why is it important to reconcile data discrepancies in healthcare? A) It helps doctors make quick decisions, even if the decision is sometimes inaccurate. B) It ensures that doctors make the right decisions based on correct information. C) It simplifies workflows by ignoring small errors in records. D) It allows treatments to continue without checking for data errors. Show Answer Correct Answer: B) It ensures that doctors make the right decisions based on correct information. 22. ..... :Builds applications that use the database. A) Developer. B) Database. C) Server. D) User. Show Answer Correct Answer: A) Developer. 23. In a relational model, an attribute refers to: A) The relationship between two tables. B) The table name. C) A row in a table. D) A column in a table. Show Answer Correct Answer: D) A column in a table. 24. What is an example of a hierarchical DBMS? A) File system B) XML database C) SQL database D) Object-oriented database A) Relational database. B) Flat file database. C) XML database. D) NoSQL database. Show Answer Correct Answer: C) XML database. 25. Which of the following in not a function of DBA? A) Authorization for data access. B) Network Maintenance. C) Routine Maintenance. D) Schema Definition. Show Answer Correct Answer: B) Network Maintenance. 26. What is a benefit of sharing data in a DBMS? A) Increased data redundancy. B) Limited access to data for security. C) Improved data integrity. D) More users can access and share data. Show Answer Correct Answer: D) More users can access and share data. 27. Name one advantage of using a DBMS over file systems. A) Lower cost of storage compared to DBMS. B) Data integrity and consistency management. C) Better support for complex queries than DBMS. D) Easier data retrieval than DBMS. Show Answer Correct Answer: B) Data integrity and consistency management. 28. What models an enterprise as a collection of entities and relationships? A) Relational model. B) Entity-Relationship data model. C) Object-based data models. D) None of the above. Show Answer Correct Answer: B) Entity-Relationship data model. 29. Which of the following are the properties of entities? A) Groups. B) Switchboards. C) Attributes. D) Tables. Show Answer Correct Answer: C) Attributes. 30. What is the purpose of a unique constraint in SQL? A) To ensure all rows in a table can have identical values. B) To prevent duplicate entries in a column that is not a primary key. C) To link two tables together. D) To automatically update data in a table. Show Answer Correct Answer: B) To prevent duplicate entries in a column that is not a primary key. 31. What is the purpose of commit control in a distributed DBMS? A) To ensure data integrity during real-time operations. B) To simplify data retrieval processes. C) To allow users to bypass data checks. D) To eliminate the need for data replication. Show Answer Correct Answer: A) To ensure data integrity during real-time operations. 32. What are some common types of database management systems? A) Object-oriented, Columnar, Spatial, Multi-model. B) Relational, In-memory, Time-series, Network. C) Relational, NoSQL, Object-oriented, Hierarchical. D) Flat-file, Graph, Document-oriented, Key-value. Show Answer Correct Answer: C) Relational, NoSQL, Object-oriented, Hierarchical. 33. Write an SQL query to update a record in the 'Students' table. A) INSERT INTO Students (column name) VALUES (new value);. B) SELECT * FROM Students WHERE condition;. C) DELETE FROM Students WHERE condition;. D) UPDATE Students SET column name = new value WHERE condition;. Show Answer Correct Answer: D) UPDATE Students SET column name = new value WHERE condition;. 34. Which DBMS user has no technical knowledge and uses pre-defined menus? A) Application Programmer. B) Online User. C) DBA. D) Naive User. Show Answer Correct Answer: D) Naive User. 35. Explain the concept of normalization in RDBMS. A) The process of increasing redundancy in a database. B) The process of encrypting data in a database. C) The process of organizing data in a database to reduce redundancy and dependency. D) The process of deleting data from a database. Show Answer Correct Answer: C) The process of organizing data in a database to reduce redundancy and dependency. 36. What attributes are included in the table for translating a relationship set into a relational model? A) Only primary key attributes. B) Primary key attributes and descriptive attributes. C) Only descriptive attributes. D) No attributes. Show Answer Correct Answer: B) Primary key attributes and descriptive attributes. 37. Which of the following is an advantage of DBMS? A) Data complexity. B) Data consistency. C) Data redundancy. D) Data confusion. Show Answer Correct Answer: B) Data consistency. 38. A subtype is a generic entity that has a relationship with one or more entities at a lower level. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 39. What uniquely identifies each tuple in a table? A) Super Key. B) Candidate Key. C) Foreign Key. D) Primary Key. Show Answer Correct Answer: D) Primary Key. 40. IIn general, a file is basically a collection of all related ..... A) Records. B) Rows & Columns. C) Fields. D) Database. Show Answer Correct Answer: A) Records. 41. What is a transaction in a database? A) A transaction is a type of database backup. B) A transaction is a way to visualize data in a database. C) A transaction is a sequence of operations treated as a single unit of work in a database. D) A transaction is a method for deleting records. Show Answer Correct Answer: C) A transaction is a sequence of operations treated as a single unit of work in a database. 42. In the context of information systems, a database is: A) A random collection of files. B) A structured collection of related data. C) Only numerical data stored in a spreadsheet. D) The same as a file system. Show Answer Correct Answer: B) A structured collection of related data. 43. Which lock allows only one transaction to write? A) Shared lock. B) Exclusive lock. C) Binary lock. D) Update lock. Show Answer Correct Answer: B) Exclusive lock. 44. What is the purpose of data integrity constraints? A) To allow unlimited data entry without restrictions. B) To enhance the speed of data retrieval in a database. C) To provide a backup for lost data in the database. D) The purpose of data integrity constraints is to maintain the accuracy and consistency of data in a database. Show Answer Correct Answer: D) The purpose of data integrity constraints is to maintain the accuracy and consistency of data in a database. 45. In a relational database, what is a 'tuple' most commonly known as? A) A record or row. B) A primary key. C) A column. D) A table. Show Answer Correct Answer: A) A record or row. 46. What is one of the main functions of a DBMS? A) Data printing. B) Data entry. C) Data visualization. D) Data storage management. Show Answer Correct Answer: D) Data storage management. 47. Database System Architecture:The organization of database, DBMS, business logic, and ..... ? A) Operating system. B) Network protocol. C) User interface. D) Data warehouse. Show Answer Correct Answer: C) User interface. 48. What does the COUNT function do? A) Finds maximum. B) Counts rows. C) Sums values. D) Finds minimum. Show Answer Correct Answer: B) Counts rows. 49. What are the main components of the Relational Model? A) Tables, Rows, Columns, Primary Keys, Foreign Keys, Constraints. B) Schemas, Views, Triggers. C) Attributes, Entities, Relationships. D) Tables, Rows, Columns, Indexes. Show Answer Correct Answer: A) Tables, Rows, Columns, Primary Keys, Foreign Keys, Constraints. 50. Object-oriented databases are widely used in enterprise applications. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 51. What is the purpose of a query language in DBMS? A) To create backups of the database. B) The purpose of a query language in DBMS is to enable users to interact with and manipulate the data stored in the database. C) To store data in a structured format. D) To ensure data security and integrity. Show Answer Correct Answer: B) The purpose of a query language in DBMS is to enable users to interact with and manipulate the data stored in the database. 52. What is the main purpose of a 'foreign key'? A) To uniquely identify each record in its own table. B) To establish and enforce a link between two tables. C) To prevent data from being modified. D) To increase data redundancy for faster lookups. Show Answer Correct Answer: B) To establish and enforce a link between two tables. 53. What does the term 'schema' refer to in a database context? A) The method of data encryption. B) The structure that defines the organization of data. C) The process of data normalization. D) The physical storage of data. Show Answer Correct Answer: B) The structure that defines the organization of data. 54. A manager has requested a list of products from highest price to lowest. How would this information be retrieved? A) Find. B) Sort Ascending. C) Sort Descending. D) Filter. Show Answer Correct Answer: C) Sort Descending. 55. What feature of a database management system helps maintain data integrity? A) Manual data entry. B) Data encryption. C) Regular data backups. D) Open access to all users. Show Answer Correct Answer: C) Regular data backups. 56. This SQL statement allows users to retrieve data from the a certain table. A) CREATE. B) ALTER. C) SELECT. D) DROP. Show Answer Correct Answer: C) SELECT. 57. ..... :Determining what actions a user can perform. A) Authorization. B) Encryption. C) Validation. D) Authentication. Show Answer Correct Answer: A) Authorization. 58. Which validation method ensures data follows a specific predefined pattern? A) Format check. B) Presence check. C) Type check. D) Range check. Show Answer Correct Answer: A) Format check. 59. What is the purpose of data validation in a database? A) To manage server-side logic. B) To create user interfaces. C) To ensure data entered meets certain criteria. D) To ensure data is stored in multiple locations. Show Answer Correct Answer: C) To ensure data entered meets certain criteria. 60. How to select all data from studentinfo table starting the name from letter 'r'? A) SELECT * FROM studentinfo WHERE sname LIKE '%r%'. B) SELECT * FROM studentinfo WHERE sname LIKE 'r%'. C) SELECT * FROM studentinfo WHERE sname LIKE '%r'. D) SELECT * FROM studentinfo WHERE sname LIKE ' r%'. Show Answer Correct Answer: B) SELECT * FROM studentinfo WHERE sname LIKE 'r%'. ← 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 7Class 12 Computer Science Chapter 3 Database Management Systems Quiz 8Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books