This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 25 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 25 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What type of distributed operation is formed by several requests that access data at a single remote site? A) Remote request. B) Remote transaction. C) Distributed transaction. D) Distributed request. Show Answer Correct Answer: D) Distributed request. 2. 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. 3. Consistency:A transaction moves the database from one valid state to ..... A) Another valid state. B) An invalid state. C) The same state. D) A temporary state. Show Answer Correct Answer: A) Another valid state. 4. A sports club needs to store information about each member. The all the information about each member is called a: A) Field. B) File. C) Table. D) Record. Show Answer Correct Answer: D) Record. 5. 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. 6. Which type of database supports multiple users at the same time? A) Multiuser database. B) Single-user database. C) Personal database. D) Distributed database. Show Answer Correct Answer: A) Multiuser database. 7. 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. 8. 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. 9. What are some common examples of DBMS software? A) Apache Hadoop. B) Microsoft Excel. C) MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, MongoDB, SQLite. D) FileMaker Pro. Show Answer Correct Answer: C) MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, MongoDB, SQLite. 10. A generic or template data model that can be reused as a starting point for a data modeling project is called a(n): A) Packaged data model. B) Universal data model. C) Enterprise data model. D) Collection data model. Show Answer Correct Answer: B) Universal data model. 11. What is the purpose of the EXTEND operation in extended relational algebra? A) Add new attributes to a table. B) Remove existing attributes from a table. C) Create a new table. D) Sort the table in descending order. Show Answer Correct Answer: A) Add new attributes to a table. 12. 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. 13. Which DBMS is commonly used by Fitbit for syncing and storing fitness data from millions of devices? A) ArangoDB. B) InfluxDB. C) Google Cloud Spanner. D) Firebase. Show Answer Correct Answer: C) Google Cloud Spanner. 14. 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. 15. Who is responsible for database security and backup? A) End User. B) System Analyst. C) Database Administrator. D) Programmer. Show Answer Correct Answer: C) Database Administrator. 16. ..... :Using data only for its intended purpose. A) Purpose Limitation. B) Data Minimization. C) Data Retention. D) Data Portability. Show Answer Correct Answer: A) Purpose Limitation. 17. 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. 18. 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. 19. 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. 20. The way a particular application views the data from the database that the application uses is a A) Module. B) Relational model. C) Schema. D) Subschema. Show Answer Correct Answer: D) Subschema. 21. 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. 22. In an SQL query, which clause is used to filter rows before grouping them? A) WHERE. B) HAVING. C) GROUP BY. D) ORDER BY. Show Answer Correct Answer: A) WHERE. 23. Which character function can be used to return a specified portion of a character string? A) INSTR. B) SUBSTR. C) POS. D) SUBSTRING. Show Answer Correct Answer: B) SUBSTR. 24. 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. 25. Which DBMS model supports many-to-many relationships using a graph structure? A) Hierarchical. B) Relational. C) Network. D) Flat File. Show Answer Correct Answer: C) Network. ← 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