This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 22 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 22 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. To which of the following the term "DBA" referred? A) Data Bank Administrator. B) Database Administrator. C) Data Administrator. D) None of the above. Show Answer Correct Answer: A) Data Bank Administrator. 2. What is the role of a database management system (DBMS)? A) A DBMS is used solely for data storage without any management features. B) The primary function of a DBMS is to create user interfaces for applications. C) A DBMS is designed to handle only large-scale data processing tasks. D) The role of a DBMS is to manage and organize data in databases, allowing for efficient data access, manipulation, and administration. Show Answer Correct Answer: D) The role of a DBMS is to manage and organize data in databases, allowing for efficient data access, manipulation, and administration. 3. In database management, what does a "shared lock" typically allow? A) Exclusive data modification. B) Reading data without updates. C) Complete data blocking. D) Permanent data storage. Show Answer Correct Answer: B) Reading data without updates. 4. Which one of the following is used to define the structure of the relation and relating schemas? A) DML(Data Manipulation Langauge). B) DDL(Data Definition Langauge). C) Query. D) Relational Schema. Show Answer Correct Answer: B) DDL(Data Definition Langauge). 5. Which of the following best describes the MPSD level of distribution? A) Multiple processes on one computer accessing a single database. B) Multiple computers accessing a single data repository. C) Multiple computers each with their own local database. D) A single computer accessing multiple databases. Show Answer Correct Answer: B) Multiple computers accessing a single data repository. 6. What does the SQL COUNT() function do? A) Counts all columns in a table. B) Counts the number of rows in a table or result set. C) Counts only numeric values. D) Counts characters in a string. Show Answer Correct Answer: B) Counts the number of rows in a table or result set. 7. If a company wants to provide database access to all its employees across different departments, which type of database should it implement? A) Enterprise database. B) Workgroup database. C) Multiuser database for a single user. D) File-based database. Show Answer Correct Answer: A) Enterprise database. 8. What is the main function of a primary key in a database? A) To link two tables. B) To uniquely identify a record. C) To store large amounts of data. D) To enforce data integrity. Show Answer Correct Answer: B) To uniquely identify a record. 9. What is one of the advantages of using a database management system (DBMS) according to the text? A) Control of data redundancy. B) Increased complexity of data storage. C) Higher cost of data maintenance. D) Limited data accessibility. Show Answer Correct Answer: A) Control of data redundancy. 10. Which one of the following is used to explain the objectives modern operating systems? A) To provide a platform on which a user can design hardware. B) To make the computer environment less convenient to use. C) To use the computer resources efficiently. D) To design algorithms. Show Answer Correct Answer: C) To use the computer resources efficiently. 11. Which of the following can add a row to a table? A) Add. B) Insert. C) Update. D) Alter. Show Answer Correct Answer: B) Insert. 12. Which one of the following commands is used for removing (or deleting) a relation forms the SQL database? A) Delete. B) Drop. C) Remove. D) All of the above. Show Answer Correct Answer: B) Drop. 13. Which combination of technologies is most suitable for developing a full-stack web application? A) HTML + JavaScript + SQL + PHP. B) HTML + CSS + Photoshop. C) Python + Excel + Bootstrap. D) Java + C++ + MongoDB. Show Answer Correct Answer: A) HTML + JavaScript + SQL + PHP. 14. The entity relationship set is represented in E-R diagram as A) Double diamonds. B) Undivided rectangles. C) Dashed lines. D) Diamond. Show Answer Correct Answer: D) Diamond. 15. What is the effect of the following SQL statement? DELETE FROM orders WHERE order ..... id = 1; A) Deletes all orders. B) Deletes the order with order id 1. C) Deletes orders with order id greater than 1. D) Deletes orders with order id less than 1. Show Answer Correct Answer: B) Deletes the order with order id 1. 16. What is a result of increased productivity in a DBMS? A) Decreased programmer productivity. B) Increased development time and cost. C) Reduced need for low-level file-handling routines. D) Higher cost of maintenance through data independence. Show Answer Correct Answer: C) Reduced need for low-level file-handling routines. 17. What is the function of a foreign key? A) To link two tables together. B) To uniquely identify a record. C) To store metadata. D) To enforce data integrity. Show Answer Correct Answer: A) To link two tables together. 18. What is a potential drawback of the complexity of a DBMS? A) Reduced need for database administrators. B) Improved performance for all users. C) Ease of understanding for end-users. D) Risk of bad design decisions. Show Answer Correct Answer: D) Risk of bad design decisions. 19. What is the output when the data '1678.95' is set to the number format '###0.00' in Access? A) 1670. B) 1670.95. C) 1678. D) 1678.95. Show Answer Correct Answer: D) 1678.95. 20. Netflix uses Cassandra because of its ability to handle which of the following? A) High-throughput. B) Low-cost storage. C) SQL queries. D) Web development. Show Answer Correct Answer: A) High-throughput. 21. A demonstration of an Agri-Information System typically includes: A) Database creation, data entry, and query-based analysis. B) Weather forecasting models only. C) Social media analytics. D) Satellite data visualization alone. Show Answer Correct Answer: A) Database creation, data entry, and query-based analysis. 22. Which of the following commands is used to save any transaction permanently into the database? A) Commit. B) Rollback. C) Savepoint. D) None of the above. Show Answer Correct Answer: A) Commit. 23. What is the logical structure of the database? A) Schema. B) Instance. C) Data Model. D) None of the above. Show Answer Correct Answer: A) Schema. 24. The term ..... is used to refer a row A) Record. B) Foreign key. C) Primary key. D) Field. Show Answer Correct Answer: A) Record. 25. Identify the major advantage of horizontal fragmentation in distributed databases? A) Increased data availability. B) Improved query performance. C) Reduced network traffic. D) Enhanced data security. Show Answer Correct Answer: C) Reduced network traffic. ← 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