This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 44 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 44 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... :Responsible management of data. A) Data Stewardship. B) Data Mining. C) Data Encryption. D) Data Visualization. Show Answer Correct Answer: A) Data Stewardship. 2. Cisco uses which DBMS to track network performance data? A) InfluxDB. B) Snowflake. C) HBase. D) Neo4j. Show Answer Correct Answer: A) InfluxDB. 3. At the external level of database abstraction, what is the user primarily concerned with? A) The internal database design. B) The data returned to their view level. C) The physical storage of data. D) The network configuration. Show Answer Correct Answer: B) The data returned to their view level. 4. Open Office base is not an open source software.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: B) B. False. 5. In a LIKE clause, you can ask for any 6 letter value by writing A) LIKE??????. B) LIKE .\{6\}. C) LIKE (that's six dots). D) LIKE (that's six underscore characters). Show Answer Correct Answer: D) LIKE (that's six underscore characters). 6. What does the term 'metadata' refer to? A) Data about data. B) Data that is no longer used. C) Data stored in a database. D) Data that is encrypted. Show Answer Correct Answer: A) Data about data. 7. What is the difference between INNER JOIN and OUTER JOIN? A) INNER JOIN can include NULL values from both tables. B) INNER JOIN returns matched rows; OUTER JOIN returns all rows from one table with matched rows from the other. C) INNER JOIN returns all rows from both tables. D) OUTER JOIN only returns unmatched rows from both tables. Show Answer Correct Answer: B) INNER JOIN returns matched rows; OUTER JOIN returns all rows from one table with matched rows from the other. 8. How do you represent an ER diagram? A) Entities as lines, attributes as stars, relationships as hexagons, connected by curves. B) Entities as ovals, attributes as diamonds, relationships as rectangles, connected by dots. C) Entities as circles, attributes as squares, relationships as triangles, connected by arrows. D) Entities as rectangles, attributes as ovals, relationships as diamonds, connected by lines. Show Answer Correct Answer: D) Entities as rectangles, attributes as ovals, relationships as diamonds, connected by lines. 9. What is vertical partitioning? A) Distributing rows of a relation among different sites. B) Storing all data in a single location. C) Distributing columns of a relation among different sites. D) Creating multiple copies of the entire database. Show Answer Correct Answer: C) Distributing columns of a relation among different sites. 10. The ..... rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship. A) Semi-specialization. B) Total specialization. C) Partial specialization. D) Total convergence. Show Answer Correct Answer: B) Total specialization. 11. What is the primary purpose of data normalisation? A) Increasing data redundancy. B) Reducing data redundancy and improving integrity. C) Speeding up database processing. D) Enhancing data security. Show Answer Correct Answer: B) Reducing data redundancy and improving integrity. 12. The process of defining one or more subtypes of a supertype and forming relationships is called: A) Specialization. B) Generalization. C) Creating discord. D) Selecting classes. Show Answer Correct Answer: A) Specialization. 13. How does a DBMS address the issue of data dependency? A) By storing data in separate linked tables. B) By storing data in a single file. C) By encrypting the data. D) By compressing the data. Show Answer Correct Answer: A) By storing data in separate linked tables. 14. How can a distributed database improve query performance? A) By processing queries closer to the location of the data. B) By storing all data on a single central server. C) By using weaker consistency models. D) By increasing data redundancy. Show Answer Correct Answer: A) By processing queries closer to the location of the data. 15. A member of a subtype does NOT necessarily have to be a member of the supertype. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 16. Why is it important for student information needed for course registration, accounting, and grade calculation to be consolidated into one standard database? A) It increases the number of databases required. B) It allows all applications to access consistent and accurate data. C) It makes data less secure. D) It reduces the need for software updates. Show Answer Correct Answer: B) It allows all applications to access consistent and accurate data. 17. What is the main purpose of database normalization? A) To increase data redundancy for faster access. B) The main purpose of database normalization is to reduce data redundancy and improve data integrity. C) To simplify database queries by merging tables. D) To enhance the visual representation of data in reports. Show Answer Correct Answer: B) The main purpose of database normalization is to reduce data redundancy and improve data integrity. 18. GUI act as front end and database server act as ..... A) Container. B) Back End. C) End. D) None of the above. Show Answer Correct Answer: B) Back End. 19. Give an example of a real-world application of a database. A) Online retail management system. B) Social media platform. C) Video streaming service. D) Weather forecasting system. Show Answer Correct Answer: A) Online retail management system. 20. What is logical data independence? A) The ability to access data without knowing its structure. B) Changing the logical schema without affecting external schemas. C) The ability to enforce data integrity. D) Changing the physical schema without affecting logical schemas. Show Answer Correct Answer: B) Changing the logical schema without affecting external schemas. 21. What is a challenge related to the performance of a DBMS? A) Increased speed of data retrieval. B) Slower execution for specific tasks. C) Efficient handling of concurrent access. D) Optimal performance for all applications. Show Answer Correct Answer: B) Slower execution for specific tasks. 22. What is the cardinality ratio for a binary relationship where a faculty may counsel many students? A) 1:1. B) 1:m. C) M:1. D) M:m. Show Answer Correct Answer: B) 1:m. 23. How do you remove a table from a database in SQL? A) DELETE TABLE. B) REMOVE TABLE. C) DROP TABLE. D) CLEAR TABLE. Show Answer Correct Answer: C) DROP TABLE. 24. How does a DBMS improve data security? A) By implementing access rights and encryption. B) By deleting old data records automatically. C) By preventing all users from modifying data. D) By removing primary keys from tables. Show Answer Correct Answer: A) By implementing access rights and encryption. 25. What is a database index used for? A) To speed up data retrieval. B) To store large amounts of data. C) To ensure data integrity. D) To create backups of the database. Show Answer Correct Answer: A) To speed up data retrieval. ← 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