This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 13 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 13 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How does the cost of conversion impact organizations using a DBMS? A) It does not require training staff to use new systems. B) It is relatively small compared to the cost of the DBMS. C) It includes the cost of converting existing applications. D) It does not involve specialist staff for conversion. Show Answer Correct Answer: C) It includes the cost of converting existing applications. 2. What is the main advantage of indexing in a database? A) Simplifies the database structure. B) Reduces storage space. C) Increases data redundancy. D) Speeds up data retrieval. Show Answer Correct Answer: D) Speeds up data retrieval. 3. Which SQL statement is used to add a new row to a table? A) INSERT ROW. B) INSERT INTO. C) ADD ROW. D) ADD INTO. Show Answer Correct Answer: B) INSERT INTO. 4. Which SQL command is used to modify existing data within a table? A) UPDATE. B) INSERT. C) DELETE. D) SELECT. Show Answer Correct Answer: A) UPDATE. 5. Lost Update Problem:When one transaction ..... updates made by another transaction. A) Reads. B) Commits. C) Overwrites. D) Ignores. Show Answer Correct Answer: C) Overwrites. 6. Which book is referenced in the resources section? A) Introduction to Database Systems. B) Fundamentals of Database Design. C) Modern Database Management Eleventh Edition. D) Database Systems:A Practical Approach. Show Answer Correct Answer: C) Modern Database Management Eleventh Edition. 7. Graph databases are ideal for social network analysis. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 8. What does data consistency refer to in the context of a DBMS? A) Allowing multiple versions of the same data. B) Ensuring data is stored only once in the database. C) Storing data redundantly for backup. D) Providing data access to unauthorized users. Show Answer Correct Answer: B) Ensuring data is stored only once in the database. 9. A workgroup database is best described as: A) A multi-user database that supports a small group of users or a single department. B) A database used only by one person. C) A database that supports an entire organization. D) A database for storing multimedia files. Show Answer Correct Answer: A) A multi-user database that supports a small group of users or a single department. 10. In SQL, what does the JOIN operation do? A) Updates rows in a table. B) Creates a new table. C) Deletes rows from a table. D) Combines rows from two or more tables. Show Answer Correct Answer: D) Combines rows from two or more tables. 11. What is the purpose of a data warehouse? A) Perform real-time data analysis. B) Manage data access permissions. C) Store data for day-to-day operations. D) Support decision-making processes by providing a consolidated view of historical data. Show Answer Correct Answer: D) Support decision-making processes by providing a consolidated view of historical data. 12. Time-series databases are optimized for storing historical data. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 13. Data mining is primarily concerned with: A) Storing and retrieving data. B) Analyzing and discovering patterns in large datasets. C) Creating graphical representations of data. D) Securing data from unauthorized access. Show Answer Correct Answer: B) Analyzing and discovering patterns in large datasets. 14. What is data replication in the context of distributed databases? A) Partitioning data into smaller segments. B) Storing a single copy of the database. C) Distributing data only horizontally. D) Creating separate copies of the database at multiple sites. Show Answer Correct Answer: D) Creating separate copies of the database at multiple sites. 15. What is the name for an answer to a query that the DBMS sends back to the application? A) DBMS result. B) Question result. C) Query result set. D) Data result. Show Answer Correct Answer: C) Query result set. 16. What is NOT a characteristic of big data? A) Volume. B) Variety. C) Vision. D) Velocity. Show Answer Correct Answer: C) Vision. 17. What is a limitation of using a DBMS for small tasks? A) Overhead is unnecessary for tiny one-off tasks. B) It is less secure. C) It is always more efficient. D) It requires complex queries. Show Answer Correct Answer: A) Overhead is unnecessary for tiny one-off tasks. 18. What is the Composite key? A) A key which has multiple attributes to uniquely identify rows in a table. B) Any part of the compound key can be a foreign key. C) The composite key may or may not be a part of the foreign key. D) All of the above. Show Answer Correct Answer: D) All of the above. 19. As a programmer, you might use comments while writing the object oriented programming using Java. How could you express such comments in Java programming? A) % . B) / . C) # . D) /* */. Show Answer Correct Answer: D) /* */. 20. Which validation rule allows only 0-9 for fields in Access? A) Is Null or Not Like "*[0-9]*". B) Is Null or Not Like "*[!0-9]*". C) Is Null or Not Like "[! 0-9]". D) Is Null or Not Like "*[ !0-9 ]*". Show Answer Correct Answer: B) Is Null or Not Like "*[!0-9]*". 21. The process of defining a more general entity type from a set of more specialized entity types is called: A) Generalization. B) Normalization. C) Extrapolation. D) Specialization. Show Answer Correct Answer: A) Generalization. 22. What is the purpose of a surrogate key? A) To create indexes. B) To uniquely identify records. C) To link tables. D) To store large data. Show Answer Correct Answer: B) To uniquely identify records. 23. What is a primary key in a relational table? A) A column containing duplicate values. B) A unique identifier for each record. C) A system-generated index. D) A foreign key from another table. Show Answer Correct Answer: B) A unique identifier for each record. 24. Which one of the following attribute can be taken as a primary key? A) Street. B) Id. C) Name. D) Department. Show Answer Correct Answer: B) Id. 25. ..... :Client performs significant processing. A) Thin Client. B) Web Client. C) Remote Client. D) Thick Client. Show Answer Correct Answer: D) Thick Client. 26. What is the transformation process of data into information? A) Contextualisation, categorisation, calculation, correction, and condensation. B) Storing data in text files. C) Creating redundancy in data storage. D) Using paper-based filing systems. Show Answer Correct Answer: A) Contextualisation, categorisation, calculation, correction, and condensation. 27. Define entity integrity in the context of databases. A) Entity integrity requires foreign keys to be unique and not null. B) Entity integrity ensures that each row in a database table is uniquely identifiable through primary keys, which must be unique and not null. C) Entity integrity allows duplicate rows in a table. D) Entity integrity is concerned with the relationships between tables. Show Answer Correct Answer: B) Entity integrity ensures that each row in a database table is uniquely identifiable through primary keys, which must be unique and not null. 28. What is a key characteristic of high-quality data? A) Timely. B) Redundant. C) Ambiguous. D) Inaccessible. Show Answer Correct Answer: A) Timely. 29. ..... is named collection of data items which represents a complete unit of information. A) Field. B) Record. C) Table. D) Data base. Show Answer Correct Answer: B) Record. 30. Why might there be multiple external views in a database system? A) To allow different users to see or view their data based on their requirements. B) To increase the speed of data processing. C) To reduce storage space. D) To encrypt all data. Show Answer Correct Answer: A) To allow different users to see or view their data based on their requirements. 31. What is the main advantage of database normalization? A) The main advantage of database normalization is to reduce data redundancy and improve data integrity. B) Simplifies complex queries and enhances performance. C) Increases data duplication and decreases data integrity. D) Eliminates the need for data backups and recovery. Show Answer Correct Answer: A) The main advantage of database normalization is to reduce data redundancy and improve data integrity. 32. Data ..... exists when the same data are stored unnecessarily at different places. A) Redundancy. B) Dependency. C) Inconsistency. D) Fragmentation. Show Answer Correct Answer: A) Redundancy. 33. What is the purpose of a data model in a DBMS? A) To provide a user interface for data entry. B) To ensure data is encrypted at all times. C) The purpose of a data model in a DBMS is to define the structure, relationships, and constraints of data. D) To store data in a flat file format. Show Answer Correct Answer: C) The purpose of a data model in a DBMS is to define the structure, relationships, and constraints of data. 34. What is a common method for testing a database? A) Data duplication testing. B) Data deletion testing. C) Data redundancy testing. D) Data integrity testing. Show Answer Correct Answer: D) Data integrity testing. 35. Which of the following is a valid time format is Access? A) Hh-mm-ss AM/PM. B) Hh:mm:ss AM/PM. C) Hh.mm.ss AM/PM. D) Hh/mm/ss AM/PM. Show Answer Correct Answer: B) Hh:mm:ss AM/PM. 36. What is the difference between a database schema and a database instance? A) A schema is the actual data in the database, while an instance is the data's definition. B) A schema is a dynamic state, while an instance is a static definition. C) A schema is only used in RDBMS, while an instance is only used in file systems. D) A schema describes the database's structure, while an instance is the data at a particular moment in time. Show Answer Correct Answer: D) A schema describes the database's structure, while an instance is the data at a particular moment in time. 37. What is the Foreign key? A) A foreign key is a column which is added to create a relationship with another table. B) Foreign keys help us to maintain data integrity. C) Every relationship in the model needs to be supported by a foreign key. D) All of the above. Show Answer Correct Answer: D) All of the above. 38. Which type of relationship exists when one row in a table can be associated with many rows in another table? A) One-to-many. B) Many-to-many. C) Self-referential. D) One-to-one. Show Answer Correct Answer: A) One-to-many. 39. Which of the following keys is generally used to represents the relationships between the tables? A) Primary key. B) Foreign key. C) Secondary key. D) None of the above. Show Answer Correct Answer: B) Foreign key. 40. ..... :Presentation, application, and database layers. A) Monolithic Architecture. B) Client-Server Model. C) Microservices Architecture. D) Three-Tier Architecture. Show Answer Correct Answer: D) Three-Tier Architecture. 41. List and explain three types of constraints in SQL. A) INDEX. B) PRIMARY KEY, FOREIGN KEY, CHECK. C) DEFAULT. D) UNIQUE. Show Answer Correct Answer: B) PRIMARY KEY, FOREIGN KEY, CHECK. 42. Database is an orderly collection of data A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 43. Consists of multiple tables of information related to common fields. A) Relational Database. B) Data Integrity. C) Big Data. D) Database Management Systems. Show Answer Correct Answer: A) Relational Database. 44. Incorrect Analysis Problem:Reading data while another transaction is ..... A) Deleting it. B) Rolling back. C) Committing it. D) Updating it. Show Answer Correct Answer: D) Updating it. 45. Which of the following is an example of a DML command? A) ALTER. B) SELECT. C) DROP. D) CREATE. Show Answer Correct Answer: B) SELECT. 46. A field of one table which is also a the primary key of another table A) Relational database. B) Foreign Key. C) Primary Key. D) Data normalisation. Show Answer Correct Answer: B) Foreign Key. 47. What is the purpose of the GROUP BY clause in SQL? A) To create new tables from existing data. B) To filter rows based on specific conditions. C) To group rows that have the same values in specified columns and perform aggregate calculations on them. D) To sort rows in ascending or descending order. Show Answer Correct Answer: C) To group rows that have the same values in specified columns and perform aggregate calculations on them. 48. ..... :Oversees information systems and data strategy. A) Chief Financial Officer (CFO). B) Chief Marketing Officer (CMO). C) Chief Operating Officer (COO). D) Chief Information Officer (CIO). Show Answer Correct Answer: D) Chief Information Officer (CIO). 49. What is the purpose of decomposition in database design? A) To simplify data. B) To create new schemas. C) To combine schemas. D) To avoid repetition. Show Answer Correct Answer: D) To avoid repetition. 50. In which type of distributed operation can a single SQL statement access data from multiple remote sites? A) Distributed transaction. B) Remote transaction. C) Distributed request. D) Remote request. Show Answer Correct Answer: C) Distributed request. 51. What is a developer interface in a DBMS? A) A feature that provides developers with commands for database management. B) A programming language used to query databases. C) A hardware device used to store data. D) A network protocol. Show Answer Correct Answer: A) A feature that provides developers with commands for database management. 52. In a ..... index, an index entry appears for only some of the search-key values. A) Dense. B) Continuous. C) Straight. D) Sparse. Show Answer Correct Answer: D) Sparse. 53. A game database designer needs to model the relationship between PLAYERS and ITEMS. Each Player can have many Items, and each Item can belong to many Players. Which type of relationship best represents this? A) Many-to-Many. B) One-to-Many. C) One-to-One. D) Create a one-to-one relationship between Players and Items. Show Answer Correct Answer: A) Many-to-Many. 54. Client/Server Architecture:Processing split between ..... and ..... A) Host, network. B) Client, server. C) Application, protocol. D) User, database. Show Answer Correct Answer: B) Client, server. 55. ..... :Unauthorized access, misuse, data loss, and system failure. A) Database Backups. B) Database Queries. C) Threats to Databases. D) Database Indexes. Show Answer Correct Answer: C) Threats to Databases. 56. How does data modeling in the hospital's database management system reduce errors? A) It allows each department to create its own patient records separately. B) It automatically eliminates the need for staff to enter patient data. C) It stores patient information without organizing it in a structured format. D) It ensures that all departments enter and access accurate and consistent information. Show Answer Correct Answer: D) It ensures that all departments enter and access accurate and consistent information. 57. In B+ tree the node which points to another node is called A) Leaf node. B) External node. C) Internal node. D) Final node. Show Answer Correct Answer: C) Internal node. 58. What is referential integrity in a database? A) Ensuring data is backed up. B) Ensuring data is unique. C) Ensuring data is not null. D) Ensuring foreign keys match primary keys. Show Answer Correct Answer: D) Ensuring foreign keys match primary keys. 59. Which HTML tag is used to create a hyperlink? A) . B) . C) . D) . Show Answer Correct Answer: A) . 60. In processes or threads concepts, there is a blocking of processes or treads that either compete for system resources or communicate with each other when each process or thread is waiting for a resource to be freed which is controlled by another process. These processes or treads could be examined with ..... A) Deadblock. B) Multithreading. C) Deadlock. D) Process Control Block. Show Answer Correct Answer: C) Deadlock. ← 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