This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 38 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 38 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In a relational schema, what is a foreign key? A) A key that uniquely identifies a record in a table. B) A key that is used for encryption. C) A reference to a primary key in another table. D) A key that allows null values. Show Answer Correct Answer: C) A reference to a primary key in another table. 2. Which of the following is a common use of SQL? A) Creating web pages. B) Managing user interfaces. C) Querying databases. D) Designing graphics. Show Answer Correct Answer: C) Querying databases. 3. What is a key advantage of using a database management system in a hospital setting? A) It provides a centralized and organized way to store patient information. B) It eliminates the need for healthcare professionals. C) It automatically diagnoses patients without human intervention. D) It allows for manual entry of patient data. Show Answer Correct Answer: A) It provides a centralized and organized way to store patient information. 4. Name a popular database management tool. A) MongoDB. B) SQLite. C) MySQL. D) PostgreSQL. Show Answer Correct Answer: C) MySQL. 5. Which function does a distributed DBMS perform? A) Keeps track of data locations in a distributed data dictionary. B) Only manages local databases. C) Requires manual data retrieval by users. D) Does not support different DBMSs at different nodes. Show Answer Correct Answer: A) Keeps track of data locations in a distributed data dictionary. 6. Purpose of Backup:To restore data after ..... failure. A) Disk. B) Network. C) Printer. D) Monitor. Show Answer Correct Answer: A) Disk. 7. Which DBMS does Amadeus use for managing travel booking data? A) Couchbase. B) Redis. C) Snowflake. D) MariaDB. Show Answer Correct Answer: A) Couchbase. 8. These are the details or characteristics of an entity A) Attribute. B) Cardinal. C) All the above. D) None of the above. Show Answer Correct Answer: A) Attribute. 9. Which of the following is not a level of data abstraction? A) Physical Level. B) Critical Level. C) Logical Level. D) View Level. Show Answer Correct Answer: B) Critical Level. 10. Serializable Schedule:A non-serial schedule that produces the same result as a ..... schedule. A) Serial. B) Parallel. C) Random. D) Deadlock. Show Answer Correct Answer: A) Serial. 11. What is the purpose of a rollback in transaction management? A) To permanently save changes made during a transaction. B) To enhance the performance of a transaction. C) To create a backup of the transaction data. D) To revert changes made during a transaction in case of an error. Show Answer Correct Answer: D) To revert changes made during a transaction in case of an error. 12. What is the purpose of the UPDATE statement in SQL? A) To delete records from a table. B) To create a new record in a table. C) To retrieve data from a table. D) To modify existing records in a table. Show Answer Correct Answer: D) To modify existing records in a table. 13. What is the purpose of the DELETE statement in SQL? A) To retrieve data from a table. B) To create a new table in the database. C) To remove rows from a table in a database. D) To update existing rows in a table. Show Answer Correct Answer: C) To remove rows from a table in a database. 14. Identify a major component of the DBMS environment. A) Network Protocol. B) Database Engine. C) Data Warehouse. D) User Interface. Show Answer Correct Answer: B) Database Engine. 15. Which of the following is an example of a relational database management system? A) MongoDB. B) Oracle. C) Redis. D) Neo4j. Show Answer Correct Answer: B) Oracle. 16. Which query is used for sorting data that retrieves all the fields from empinfo table and listed them in the ascending order? A) SELECT * FROM empinfo ORDER BY age;. B) SELECT * FROM empinfo ORDER age;. C) SELECT * FROM empinfo ORDER BY COLUMN age;. D) SELECT * FROM empinfo SORT BY age;. Show Answer Correct Answer: A) SELECT * FROM empinfo ORDER BY age;. 17. A company is experiencing frequent upgrade and replacement cycles with their DBMS. What strategic action could they take to minimize disruption? A) Develop a long-term upgrade plan and schedule regular maintenance. B) Ignore upgrades and continue using outdated software. C) Switch to manual record keeping. D) Rely solely on vendor recommendations without internal planning. Show Answer Correct Answer: A) Develop a long-term upgrade plan and schedule regular maintenance. 18. When normalizing a database, what is the main goal of transforming it into the Third Normal Form (3NF)? A) To ensure data is atomic. B) To remove transitive dependencies. C) To reduce the number of tables. D) To increase data redundancy. Show Answer Correct Answer: B) To remove transitive dependencies. 19. A subtype can become a supertype if the subtype has other subtypes beneath it. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 20. What does the term 'schema' refer to in a database? A) The user interface. B) The physical storage of data. C) The structure of the database. D) The data itself. Show Answer Correct Answer: C) The structure of the database. 21. All of the following are steps to using a packaged data model EXCEPT: A) Identify the parts of the data model that apply to your data modeling situation. B) Utilize all business rules that come with the packaged data model. C) Rename the identified data elements. D) Map data to be used in packages with existing data in the current databases. Show Answer Correct Answer: B) Utilize all business rules that come with the packaged data model. 22. What is the significance of data independence for database users? A) Data independence prevents users from modifying the database structure. B) Data independence is significant as it enables changes to the database schema without impacting application programs. C) Data independence is crucial for ensuring data is always encrypted. D) Data independence allows users to access data without any restrictions. Show Answer Correct Answer: B) Data independence is significant as it enables changes to the database schema without impacting application programs. 23. What does the MIN function do? A) Sums values. B) Counts values. C) Finds the minimum value. D) Finds the maximum value. Show Answer Correct Answer: C) Finds the minimum value. 24. What does the LEFT JOIN do? A) Returns all records from the right table. B) Returns no records. C) Returns all records from the left table. D) Returns matching records only. Show Answer Correct Answer: C) Returns all records from the left table. 25. Which of the following is a benefit of using forms in a database? A) They increase data redundancy. B) They simplify data entry. C) They complicate data retrieval. D) They reduce data security. Show Answer Correct Answer: B) They simplify data entry. ← 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