This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 61 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 61 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which model uses a tree structure? A) Hierarchical Model. B) Network Model. C) Object Oriented Model. D) Relational Model. Show Answer Correct Answer: A) Hierarchical Model. 2. What is the purpose of the FOREIGN KEY in a database? A) To ensure data integrity between two tables. B) To remove duplicate records. C) To create a backup of the database. D) To update records in a table. Show Answer Correct Answer: A) To ensure data integrity between two tables. 3. Which of the following field of table "Book" can act as primary key? A) Book number. B) Subject. C) Price. D) Author name. Show Answer Correct Answer: A) Book number. 4. What are the different events in Triggers? A) Define, Create. B) Drop, Comment. C) Insert, Update, Delete. D) Select, Commit. Show Answer Correct Answer: C) Insert, Update, Delete. 5. In a hospital database, which DBMS component ensures unique patient IDs? A) Foreign Key. B) Primary Key. C) Index. D) View. Show Answer Correct Answer: B) Primary Key. 6. Which validation rule allows only positive numbers for fields in? A) Is Null or > = 0. B) Is Null or Positive. C) Is Null or < 0. D) Is Null or = "+". Show Answer Correct Answer: A) Is Null or > = 0. 7. How does a DBMS ensure data consistency? A) By ignoring user access controls. B) By enforcing ACID properties. C) By allowing unlimited data duplication. D) By using a single database file. Show Answer Correct Answer: B) By enforcing ACID properties. 8. Which of the following database applications uses a centralized database system? A) Airline reservation system. B) Social media platforms. C) E-commerce websites. D) Distributed file systems. Show Answer Correct Answer: A) Airline reservation system. 9. Which key stoke is used to move the active cell towards right, in access table? A) Ctrl + Tab. B) Alt + Tab. C) Tab. D) Shift + Tab. Show Answer Correct Answer: C) Tab. 10. In the context of normalization, a table is considered to be in 'Second Normal Form' (2NF) if it is in 1NF and what other condition is met? A) All non-key attributes are dependent on the entire primary key. B) It has no repeating groups. C) It has no transitive dependencies. D) All non-key attributes are dependent on another non-key attribute. Show Answer Correct Answer: A) All non-key attributes are dependent on the entire primary key. 11. What is the purpose of a backup procedure in a DBMS? A) To restore data in case of failure. B) To delete old tables. C) To speed up data retrieval. D) To enforce referential integrity. Show Answer Correct Answer: A) To restore data in case of failure. 12. What shape represents entities in an ER diagram? A) Circle. B) Rectangle. C) Triangle. D) Diamond. Show Answer Correct Answer: B) Rectangle. 13. What is the function of a foreign key in a database? A) To ensure data integrity by linking tables. B) To store encrypted data. C) To increase the speed of data retrieval. D) To define the structure of a database. Show Answer Correct Answer: A) To ensure data integrity by linking tables. 14. How many tables are required for a strong entity set with multi-valued attributes? A) One table. B) Two tables. C) Three tables. D) Four tables. Show Answer Correct Answer: B) Two tables. 15. In a DBMS, the "metadata" refers to: A) The actual data stored in the tables. B) Data about data. C) Temporary data. D) Encrypted data. Show Answer Correct Answer: B) Data about data. 16. What is the main purpose of referential integrity constraints? A) To define the structure of a table. B) To enforce unique values in a column. C) To ensure data accuracy and reliability. D) To limit the range of values for attributes. Show Answer Correct Answer: C) To ensure data accuracy and reliability. 17. Why are databases important in hospitals? A) To track staff schedules. B) To monitor patient records and ensure accuracy. C) To manage social media accounts. D) To recommend treatment options automatically. Show Answer Correct Answer: B) To monitor patient records and ensure accuracy. 18. What is a potential downside of the size of a DBMS? A) Requirement for substantial memory and disk space. B) Minimal impact on memory usage. C) Decreased need for additional storage. D) Low cost of hardware procurement. Show Answer Correct Answer: A) Requirement for substantial memory and disk space. 19. What do RDBMS use for data manipulation? A) HTML. B) Structured Query Language (SQL). C) Java. D) Python. Show Answer Correct Answer: B) Structured Query Language (SQL). 20. The structure representing the organizational view of entire database is known as ..... inMySQL database. A) Schema. B) View. C) Instance. D) Table. Show Answer Correct Answer: A) Schema. 21. Which component of a DBMS defines how data is structured and stored? A) Logical schema. B) Query processor. C) Data dictionary. D) Report generator. Show Answer Correct Answer: A) Logical schema. 22. Which one of the following protocols includes under internet/internetworking layer TCP/IP layer? A) Transmission Control Protocol. B) File Transfer Protocol. C) Simple Mail Transfer Protocol. D) Address Resolution Protocol. Show Answer Correct Answer: D) Address Resolution Protocol. 23. What is the role of relational query languages in database management? A) Define the physical storage structure of the database. B) Perform mathematical operations on the database. C) Provide a way to interact with the database using queries. D) Ensure data consistency in the database. Show Answer Correct Answer: C) Provide a way to interact with the database using queries. 24. Name three common techniques for optimizing SQL queries. A) Database Normalization. B) Using Stored Procedures. C) Indexing, Query Rewriting, Analyzing Execution Plans. D) Data Encryption. Show Answer Correct Answer: C) Indexing, Query Rewriting, Analyzing Execution Plans. 25. Which combination of key allows user to move to the first field in the first record in Access table? A) Ctrl + Tab. B) Shift +Tab. C) Shift + Home. D) Ctrl + Home. Show Answer Correct Answer: D) Ctrl + Home. ← 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