This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 42 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 42 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What are primary keys and foreign keys in a database? A) Primary keys can be duplicated across tables. B) Primary keys uniquely identify records in a table; foreign keys link records between tables. C) Foreign keys are used to store images in a database. D) Primary keys are used for indexing data only. Show Answer Correct Answer: B) Primary keys uniquely identify records in a table; foreign keys link records between tables. 2. A company needs to generate monthly sales reports from its database. Which DBMS function would be primarily involved in storing the report definitions and related data entry forms? A) Data storage management. B) Data transformation and presentation. C) Data dictionary management. D) Data encryption. Show Answer Correct Answer: A) Data storage management. 3. A website developer wants to create a dynamic web application that updates content without reloading the page. Which web technology should he/she use? A) HTML5. B) AJAX. C) CSS3. D) FTP. Show Answer Correct Answer: B) AJAX. 4. How does a DBMS support data integrity? A) A DBMS ensures data integrity by enforcing constraints, data types, and transaction management. B) A DBMS only stores data without any integrity checks. C) A DBMS does not support data integrity at all. D) Data integrity is managed solely by the application layer. Show Answer Correct Answer: A) A DBMS ensures data integrity by enforcing constraints, data types, and transaction management. 5. What is one advantage of RDBMS? A) It is always slow. B) It can handle large amounts of data. C) It is only for small data. D) It does not allow data security. Show Answer Correct Answer: B) It can handle large amounts of data. 6. Which of the following is an example of agricultural database usage? A) Crop disease prediction system. B) Computer game design. C) Online video streaming. D) Image editing. Show Answer Correct Answer: A) Crop disease prediction system. 7. What does data independence refer to in DBMS? A) The ability to store data in multiple formats. B) Data independence refers to the ability to change the database schema at one level without affecting other levels. C) The method of encrypting data for security. D) The process of backing up data regularly. Show Answer Correct Answer: B) Data independence refers to the ability to change the database schema at one level without affecting other levels. 8. What is the purpose of the UNION operator in SQL? A) To combine the results of two or more SELECT statements into a single result set. B) To filter records based on specified conditions. C) To sort the result set in ascending order. D) To create a new table in the database. Show Answer Correct Answer: A) To combine the results of two or more SELECT statements into a single result set. 9. What does the MAX function do? A) Calculates the average. B) Counts values. C) Finds the maximum value. D) Finds the minimum value. Show Answer Correct Answer: C) Finds the maximum value. 10. A ..... does not have a distinguishing attribute if its own and most are dependent entities, which are part of some another entity. A) Weak entity. B) Strong entity. C) Non-attributes entity. D) Dependent entity. Show Answer Correct Answer: A) Weak entity. 11. In a relational model, the term "attribute" refers to a: A) Row in a table. B) Column in a table. C) Relationship between tables. D) Key that links two tables. Show Answer Correct Answer: B) Column in a table. 12. Which of the following is used to sort the result set in SQL? A) SORT BY. B) ARRANGE BY. C) ORDER BY. D) GROUP BY. Show Answer Correct Answer: C) ORDER BY. 13. What is information? A) Processed data B) Unorganized facts C) A type of hardware D) A programming language A) A) Processed data. B) A type of software. C) A method of communication. D) Random numbers. Show Answer Correct Answer: A) A) Processed data. 14. What is the purpose of the DISTINCT keyword in SQL? A) To join two or more tables together. B) To filter records based on specified conditions. C) To sort the result set in ascending order. D) To retrieve unique values from a column in a table. Show Answer Correct Answer: D) To retrieve unique values from a column in a table. 15. What type of integrity constraint ensures that every attribute has a specific range of values? A) Entity Constraints. B) Referential Integrity Constraints. C) Domain Constraints. D) Key Constraints. Show Answer Correct Answer: C) Domain Constraints. 16. What is the main role of the 'conceptual schema' in database architecture? A) To define the physical storage details of the data. B) To provide different user views of the database. C) To define the overall logical structure of the database, independent of its physical storage. D) To manage the permissions and access controls for all users. Show Answer Correct Answer: C) To define the overall logical structure of the database, independent of its physical storage. 17. The following diagram shows: A) Total specialization. B) Partial specialization. C) The overlap rule. D) Subtype discriminator. Show Answer Correct Answer: D) Subtype discriminator. 18. Ted is creating a database for several customers. What is the data type for the field customer name? A) Yes/No. B) Data. C) Number. D) Currency. Show Answer Correct Answer: B) Data. 19. RDBMS is less expensive to set up compared to NoSQL databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 20. The SQL ALTER TABLE command is used to: A) Delete records from a table. B) Modify the structure of a table. C) Create a new table. D) Change the database name. Show Answer Correct Answer: B) Modify the structure of a table. 21. NoSQL databases are known for their rigid schema designs. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 22. Which query language is used for relational databases? A) SQL. B) HTML. C) XML. D) NoSQL. Show Answer Correct Answer: A) SQL. 23. What describes the physical structure of the database? A) Internal or Physical level. B) Conceptual or Logical level. C) External or View level. D) None of the above. Show Answer Correct Answer: A) Internal or Physical level. 24. What is a drawback of the cost of conversion to a DBMS? A) Ease of transitioning existing applications. B) Employment of specialist staff for conversion. C) Low training costs for staff. D) Smooth integration with legacy systems. Show Answer Correct Answer: B) Employment of specialist staff for conversion. 25. Why might "Data Independence" be an important topic in the context of "Levels of Data Representation" ? A) It allows changes in data structure without affecting application programs. B) It helps in designing user interfaces. C) It improves internet speed. D) It increases the size of the database. Show Answer Correct Answer: A) It allows changes in data structure without affecting application programs. ← 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