This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 5 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 5 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The main purpose of MS Access in agriculture is to: A) Create 3D crop models. B) Maintain and analyze agricultural data easily. C) Perform weather forecasting. D) Edit satellite images. Show Answer Correct Answer: B) Maintain and analyze agricultural data easily. 2. Which JOIN returns all rows from both tables, matching them where possible? A) INNER JOIN. B) LEFT JOIN. C) RIGHT JOIN. D) FULL OUTER JOIN. Show Answer Correct Answer: D) FULL OUTER JOIN. 3. Which command quickly locates the data is Access table? A) Find. B) Locate. C) Search. D) Edit. Show Answer Correct Answer: A) Find. 4. Explain the difference between a relational and a non-relational database. A) Relational databases store data in JSON format. B) Relational databases are only used for large datasets. C) Relational databases use structured tables and SQL, while non-relational databases use flexible formats and various query methods. D) Non-relational databases require SQL for data manipulation. Show Answer Correct Answer: C) Relational databases use structured tables and SQL, while non-relational databases use flexible formats and various query methods. 5. Which company uses SAP HANA to manage data from production lines? A) Mercedes-Benz. B) Reddit. C) Fitbit. D) Airbnb. Show Answer Correct Answer: A) Mercedes-Benz. 6. What is an advantage of role-based views in a DBMS? A) They eliminate redundancy. B) They are always accurate. C) They require no training. D) They show different slices of data. Show Answer Correct Answer: D) They show different slices of data. 7. Which level of data and process distribution would be most appropriate for a multinational company with offices and data centers in multiple countries? A) SPSD. B) MPSD. C) MPMD. D) None of the above. Show Answer Correct Answer: C) MPMD. 8. The candidate key that you choose to identify each row uniquely is called ..... A) Super key. B) Primary key. C) Alternate key. D) Unique key. Show Answer Correct Answer: B) Primary key. 9. Which term refers to data about data in a database? A) Metadata. B) Instance. C) Schema. D) Data dictionary. Show Answer Correct Answer: A) Metadata. 10. The ..... determines what values are stored in the table. A) Table. B) Column. C) Row. D) Record. Show Answer Correct Answer: B) Column. 11. Which of the following defines the structure of a relation that consists of a fixed set of attribute-domain pairs. A) Instance. B) Schema. C) Program. D) Super key. Show Answer Correct Answer: B) Schema. 12. What is the purpose of the "Varchar" data type in MariaDB? A) To store fixed-length strings. B) To store variable-length strings up to a specified number of characters. C) To store integers only. D) To store boolean values. Show Answer Correct Answer: B) To store variable-length strings up to a specified number of characters. 13. A unique identifying field. A) Primary Key. B) Integer. C) Verification. D) Boolean. Show Answer Correct Answer: A) Primary Key. 14. Which of the following best describes a centralized database architecture? A) All data are located at a single site. B) Data are distributed across several different sites. C) Data are stored only on personal computers. D) Data are only accessible by one user at a time. Show Answer Correct Answer: A) All data are located at a single site. 15. What is the ability to change a schema at one level without affecting the higher level schemas called? A) Data Independence. B) Mapping. C) Schema. D) None of the above. Show Answer Correct Answer: A) Data Independence. 16. What is the main advantage of using a DBMS over a traditional file system? A) It is easier to lose data. B) It provides better data security, integrity, and reduces data redundancy. C) It requires no technical knowledge. D) It is only suitable for small amounts of data. Show Answer Correct Answer: B) It provides better data security, integrity, and reduces data redundancy. 17. Empdt1(empcode, name, street, city, state, pincode).For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in A) 1 NF only. B) 2 NF and hence also in 1 NF. C) 3NF and hence also in 2NF and 1NF. D) BCNF and hence also in 3NF, 2NF and 1NF. Show Answer Correct Answer: B) 2 NF and hence also in 1 NF. 18. Which SQL command is used to remove a table from a database? A) DELETE. B) DROP. C) ERASE. D) REMOVE. Show Answer Correct Answer: B) DROP. 19. Which characteristic distinguishes quantitative data from qualitative data? A) Numerical nature. B) Complexity of collection. C) Storage requirements. D) Processing speed. Show Answer Correct Answer: A) Numerical nature. 20. What is the purpose of a query optimizer in a DBMS? A) To store data. B) To improve query performance. C) To manage user access. D) To create backups. Show Answer Correct Answer: B) To improve query performance. 21. What is meant by less redundancy in DBMS? A) Less redundancy means minimizing duplicate data in a DBMS. B) Less redundancy refers to having more data copies for safety. C) Less redundancy means increasing data storage capacity. D) Less redundancy indicates a higher number of data entries. Show Answer Correct Answer: A) Less redundancy means minimizing duplicate data in a DBMS. 22. Which of the following gives a logical structure of the database graphically? A) Entity-relationship diagram. B) Entity diagram. C) Database diagram. D) Architectural representation. Show Answer Correct Answer: A) Entity-relationship diagram. 23. Describe the role of a database administrator (DBA). A) Creating marketing strategies for database products. B) Writing code for database queries. C) The role of a database administrator (DBA) includes managing, maintaining, and securing database systems. D) Designing user interfaces for applications. Show Answer Correct Answer: C) The role of a database administrator (DBA) includes managing, maintaining, and securing database systems. 24. A company currently uses spreadsheets for payroll. Which is the best reason to switch to a DBMS? A) DBMS is easier to install than Excel. B) DBMS prevents redundancy and ensures data consistency. C) DBMS requires no technical knowledge. D) DBMS eliminates all data errors automatically. Show Answer Correct Answer: B) DBMS prevents redundancy and ensures data consistency. 25. What is the purpose of the authorization manager in a DBMS? A) To control user access to data. B) To manage data storage. C) To optimize query performance. D) To ensure data integrity. Show Answer Correct Answer: A) To control user access to data. ← 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 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 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books