This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 10 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A database that stores information about farmers, crops, soil tests, and yields can be categorized as: A) Agricultural Information System (Agri-IS). B) Multimedia Database. C) Statistical Database. D) Temporal Database. Show Answer Correct Answer: A) Agricultural Information System (Agri-IS). 2. How many tables are needed for a strong entity set with multi-valued attributes? A) Three. B) One. C) Two. D) Four. Show Answer Correct Answer: C) Two. 3. ACID properties are essential for ensuring data reliability in financial transactions. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 4. What is a transaction in the context of database management? A) A transaction is a method for deleting all records in a database. B) A transaction is a backup of the database. C) A transaction is a type of database that stores data permanently. D) A transaction is a sequence of operations treated as a single unit of work in a database. Show Answer Correct Answer: D) A transaction is a sequence of operations treated as a single unit of work in a database. 5. Occurs when multiple users seeking access to the same set of records lockout each other. A) Deadlock. B) Database lockout. C) Data manipulation. D) Data redundancy. Show Answer Correct Answer: A) Deadlock. 6. ..... :Business logic layer. A) Network Tier. B) Application Tier. C) Presentation Tier. D) Data Tier. Show Answer Correct Answer: B) Application Tier. 7. What is the purpose of keys in a relational database? A) To encrypt sensitive data in the database. B) The purpose of keys in a relational database is to uniquely identify records and establish relationships between tables. C) To store large binary files efficiently. D) To improve the speed of data retrieval operations. Show Answer Correct Answer: B) The purpose of keys in a relational database is to uniquely identify records and establish relationships between tables. 8. What is an Entity-Relationship (ER) model used for? A) To encrypt data. B) To manage user access. C) To visualize data relationships. D) To store data. Show Answer Correct Answer: C) To visualize data relationships. 9. .... is a database tool used by developers and DBA's mainly for visualization. A) PHPMYADMIN. B) HeidiSQL. C) Python. D) MySQL Workbench. Show Answer Correct Answer: D) MySQL Workbench. 10. Define the term 'data integrity' in the context of databases. A) Data integrity refers to the speed of data retrieval in a database. B) Data integrity is the process of backing up data regularly. C) Data integrity is the accuracy, consistency, and reliability of data in a database. D) Data integrity means the amount of data stored in a database. Show Answer Correct Answer: C) Data integrity is the accuracy, consistency, and reliability of data in a database. 11. Shared Lock (S Lock):Allows multiple transactions to ..... a data item. A) Write. B) Delete. C) Read. D) Update. Show Answer Correct Answer: C) Read. 12. A search key containing more than one attribute is referred to as a ..... search key. A) Composite. B) Secondary. C) Simple. D) Compound. Show Answer Correct Answer: A) Composite. 13. Which language is commonly used to interact with a relational DBMS? A) HTML. B) SQL. C) XML. D) CSS. Show Answer Correct Answer: B) SQL. 14. The following figure shows an example of: A) The overlap rule. B) The disjoint rule. C) The completeness rule. D) The underdog rule. Show Answer Correct Answer: A) The overlap rule. 15. Which of the following is NOT a function of DBMS? A) Construct Database. B) Destroy Hardware. C) Define Data. D) Manipulate Data. Show Answer Correct Answer: B) Destroy Hardware. 16. Define a relational data structure. A) A relational data structure is a single table without any relationships. B) A relational data structure is a type of data structure that only stores numeric values. C) A relational data structure is a collection of unrelated data points. D) A relational data structure is a collection of data organized into tables (relations) that can be linked by relationships. Show Answer Correct Answer: D) A relational data structure is a collection of data organized into tables (relations) that can be linked by relationships. 17. A description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data. A) Subschema. B) Schema. C) Physical view. D) Logical view. E) External-level schema. Show Answer Correct Answer: B) Schema. 18. Which tool is used by a DBA to manage the database? A) Query Tools. B) Administration Tools. C) Web Browser. D) Text Editor. Show Answer Correct Answer: B) Administration Tools. 19. What is the primary purpose of SQL? A) To manage and manipulate relational databases. B) To store and retrieve files on a server. C) To create and design websites. D) To perform complex mathematical calculations. Show Answer Correct Answer: A) To manage and manipulate relational databases. 20. Which of the following is not a Storage Manager Component? A) File Manager. B) Buffer Manager. C) Logical Manager. D) Transaction Manager. Show Answer Correct Answer: C) Logical Manager. 21. Billy is creating a database for several customers. How will he record whether or not they have a credit card? A) Yes/No. B) Text. C) Currency. D) Number. Show Answer Correct Answer: A) Yes/No. 22. ..... :Clearly explaining how data is collected and used. A) Transparency. B) Secrecy. C) Ambiguity. D) Obscurity. Show Answer Correct Answer: A) Transparency. 23. E-R model uses this symbol to represent weak entity set? A) Dotted rectangle. B) Diamond. C) Doubly outlined rectangle. D) None of these. Show Answer Correct Answer: C) Doubly outlined rectangle. 24. The process of organizing data to reduce redundancy is called: A) Normalization. B) Aggregation. C) Indexing. D) Querying. Show Answer Correct Answer: A) Normalization. 25. Which of the following is a disadvantage of file processing systems? A) Data redundancy. B) High data security. C) Multi-user access support. D) Efficient data handling. Show Answer Correct Answer: A) Data redundancy. 26. Which of the following is NOT a type of database architecture? A) Client-Server. B) Hierarchical. C) Flat-file. D) Parallel. Show Answer Correct Answer: D) Parallel. 27. There are six computers to be connected with each other through a connectivity device called hub. What will you do to create this connection? A) Create mesh topology by connecting each other. B) Create bus topology with straight line cable. C) Create star topology by using connectivity device. D) Create ring topology by cyclic process. Show Answer Correct Answer: C) Create star topology by using connectivity device. 28. Purpose of Log:To support undo and redo during ..... A) Recovery. B) Execution. C) Compilation. D) Encryption. Show Answer Correct Answer: A) Recovery. 29. Duplicate values can be entered in primary key.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: B) B. False. 30. The figure below is an example of a(n): A) Entity cluster. B) Supertype/subtype hierarchy. C) Column cluster. D) Hierarchical data model. Show Answer Correct Answer: B) Supertype/subtype hierarchy. 31. What is a disadvantage of using a DBMS? A) Complexity B) Easy to use C) Low cost D) High performance A) A. B) User-friendly interface. C) Affordable maintenance. D) Scalability issues. Show Answer Correct Answer: A) A. 32. Which of the following is not the type of the data model? A) Object Oriented Model. B) Relational Data Model. C) Process-based Data Model. D) Entity-Relationship Model. Show Answer Correct Answer: C) Process-based Data Model. 33. Which of the following are introduced to reduce the overheads caused by the log-based recovery? A) Locks. B) Deadlocks. C) Checkpoints. D) Indices. Show Answer Correct Answer: C) Checkpoints. 34. The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 35. Which DBMS does Bank of America use to manage transaction processing? A) Snowflake. B) PostgreSQL. C) IBM Db2. D) Amazon DynamoDB. Show Answer Correct Answer: C) IBM Db2. 36. Is a file-based system suitable for a small sari-sari store? A) Yes, because it is cost-effective. B) No, because it wastes storage. C) Yes, because it is faster than DBMS. D) No, because it cannot handle text. Show Answer Correct Answer: A) Yes, because it is cost-effective. 37. What type of distributed operation is formed by several requests that access data at a single remote site? A) Distributed transaction. B) Distributed request. C) Remote transaction. D) Remote request. Show Answer Correct Answer: B) Distributed request. 38. What is a query processor in a DBMS? A) A feature that processes and executes queries written in SQL. 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 processes and executes queries written in SQL. 39. Consistency:A transaction moves the database from one valid state to ..... A) A temporary state. B) An invalid state. C) Another valid state. D) The same state. Show Answer Correct Answer: C) Another valid state. 40. A sports club needs to store information about each member. The all the information about each member is called a: A) File. B) Field. C) Record. D) Table. Show Answer Correct Answer: C) Record. 41. Which of the following is a characteristic of a logical schema? A) It defines the physical storage structure of a database. B) It represents the overall design and structure of a database. C) It ensures data consistency and integrity. D) It provides a user-friendly interface for database access. Show Answer Correct Answer: B) It represents the overall design and structure of a database. 42. Which type of database supports multiple users at the same time? A) Single-user database. B) Personal database. C) Distributed database. D) Multiuser database. Show Answer Correct Answer: D) Multiuser database. 43. Referential integrity ensures: A) That foreign key values match primary key values in the related table. B) That all columns contain unique values. C) That null values are removed. D) That indexes are automatically created. Show Answer Correct Answer: A) That foreign key values match primary key values in the related table. 44. How does a DBMS act as an intermediate in database management? A) It connects the user directly to the database hardware. B) It serves as the intermediate between the user and the database. C) It only stores backup copies of the database. D) It encrypts all database files automatically. Show Answer Correct Answer: B) It serves as the intermediate between the user and the database. 45. What are some common examples of DBMS software? A) FileMaker Pro. B) MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, MongoDB, SQLite. C) Microsoft Excel. D) Apache Hadoop. Show Answer Correct Answer: B) MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, MongoDB, SQLite. 46. A generic or template data model that can be reused as a starting point for a data modeling project is called a(n): A) Universal data model. B) Packaged data model. C) Collection data model. D) Enterprise data model. Show Answer Correct Answer: A) Universal data model. 47. What is the purpose of the EXTEND operation in extended relational algebra? A) Add new attributes to a table. B) Sort the table in descending order. C) Remove existing attributes from a table. D) Create a new table. Show Answer Correct Answer: A) Add new attributes to a table. 48. In the network model, how are entities organized? A) As an inverted tree. B) In a graph. C) In two-dimensional tables. D) None of the above. Show Answer Correct Answer: B) In a graph. 49. Which DBMS is commonly used by Fitbit for syncing and storing fitness data from millions of devices? A) ArangoDB. B) Firebase. C) InfluxDB. D) Google Cloud Spanner. Show Answer Correct Answer: D) Google Cloud Spanner. 50. What is the requirement to share files with peer-to-peer network? A) Two computers should have the same name and host address. B) Two computers should have the same network address but different host address. C) File sharing, network sharing and printer sharing should be disabled. D) Two computers should have the same network and host address. Show Answer Correct Answer: B) Two computers should have the same network address but different host address. 51. Who is responsible for database security and backup? A) Programmer. B) End User. C) System Analyst. D) Database Administrator. Show Answer Correct Answer: D) Database Administrator. 52. ..... :Using data only for its intended purpose. A) Data Portability. B) Data Retention. C) Data Minimization. D) Purpose Limitation. Show Answer Correct Answer: D) Purpose Limitation. 53. What is a consequence of the size of a DBMS? A) Minimal disk space requirements. B) Limited functionality for users. C) Low memory usage for efficient running. D) Increased cost of hardware and storage. Show Answer Correct Answer: D) Increased cost of hardware and storage. 54. It is a major element in a retail information system, and may be used with customer databases, vendor databases and product category databases. A) Database management. B) Data warehousing. C) Retail Information System. D) None of the above. Show Answer Correct Answer: A) Database management. 55. Which of the following is a limitation of manual file handling? A) Difficult to update and retrieve data. B) Low error rate. C) Easy data organization. D) High efficiency. Show Answer Correct Answer: A) Difficult to update and retrieve data. 56. The way a particular application views the data from the database that the application uses is a A) Module. B) Schema. C) Relational model. D) Subschema. Show Answer Correct Answer: D) Subschema. 57. Which of the following is an example of a relational database management system (RDBMS)? A) MongoDB. B) Oracle. C) Redis. D) Cassandra. Show Answer Correct Answer: B) Oracle. 58. In an SQL query, which clause is used to filter rows before grouping them? A) WHERE. B) GROUP BY. C) ORDER BY. D) HAVING. Show Answer Correct Answer: A) WHERE. 59. Which character function can be used to return a specified portion of a character string? A) INSTR. B) POS. C) SUBSTR. D) SUBSTRING. Show Answer Correct Answer: C) SUBSTR. 60. A hospital requires a system that ensures only authorized personnel can view patients' medical records while providing an organized structure for large amounts of data. True or false:A database management system replaces the need for healthcare professionals. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. ← 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