This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 43 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 43 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the function of a Database Administrator (DBA)? A) Develop software applications. B) Design database tables. C) Manage and maintain the database system. D) Write SQL queries. Show Answer Correct Answer: C) Manage and maintain the database system. 2. Explain the concept of referential integrity. A) Referential integrity ensures that foreign keys in a database correctly reference primary keys in related tables, maintaining data consistency. B) Referential integrity allows any foreign key to reference any table. C) Referential integrity is the process of deleting all records in a database. D) Referential integrity ensures that all tables in a database are identical. Show Answer Correct Answer: A) Referential integrity ensures that foreign keys in a database correctly reference primary keys in related tables, maintaining data consistency. 3. Select a query that retrieves all of the unique courses from the student table? A) SELECT DISTINCT coursename FROM studentinfo;. B) SELECT UNIQUE coursename FROM studentinfo;. C) SELECT DISTINCT coursename FROM TABLE studentinfo;. D) SELECT INDIVIDUAL coursename FROM studentinfo;. Show Answer Correct Answer: A) SELECT DISTINCT coursename FROM studentinfo;. 4. What are rows and columns in the context of RDBMS? A) Rows are vertical records and columns are horizontal fields in a table. B) Rows are horizontal records and columns are vertical fields in a table. C) Rows are fields and columns are records in a table. D) Rows are vertical fields and columns are horizontal records in a table. Show Answer Correct Answer: B) Rows are horizontal records and columns are vertical fields in a table. 5. Minimal data redundancy in databases means: A) Reduced instances of data duplication. B) Increased data duplication. C) No control over redundancy. D) Data is not shared. Show Answer Correct Answer: A) Reduced instances of data duplication. 6. Which are the two ways in which entities can participate in a relationship? A) Passive and active. B) Total and partial. C) Simple and Complex. D) All of the above. Show Answer Correct Answer: B) Total and partial. 7. Which of the following describes a tuple in a relational database? A) A type of data constraint. B) A row in a table. C) A column in a table. D) A unique identifier for a record. Show Answer Correct Answer: B) A row in a table. 8. When data is stored, maintained and retrieved from multiple tables then special database software are required called ..... A) DBMS. B) RDBMS. C) Special DBMS. D) All of the above. Show Answer Correct Answer: B) RDBMS. 9. ..... :Client performs minimal processing. A) Thin Client. B) Fat Client. C) Smart Client. D) Rich Client. Show Answer Correct Answer: A) Thin Client. 10. What is an advantage of using indexes in a DBMS? A) They are always free. B) They require no training. C) They enable fast lookups. D) They eliminate redundancy. Show Answer Correct Answer: C) They enable fast lookups. 11. A table is in the ..... if only candidate keys are the determinants. A) Functional dependency. B) Transitive dependency. C) 3NF. D) BCNF. Show Answer Correct Answer: D) BCNF. 12. What is the purpose of the ALTER TABLE statement in SQL? A) To create a new table in the database. B) To retrieve data from a table. C) To delete a table from the database. D) To modify an existing table structure. Show Answer Correct Answer: D) To modify an existing table structure. 13. In a database system, the term 'schema' refers to: A) A snapshot of the data at a particular instant. B) The physical structure of the database. C) The overall logical structure of the database. D) The data types used in the database. Show Answer Correct Answer: C) The overall logical structure of the database. 14. Instagram uses which DBMS to store large-scaled distributed data? A) Microsoft SQL Server. B) PostgreSQL. C) MongoDB. D) Cassandra. Show Answer Correct Answer: D) Cassandra. 15. Which DBMS does Lyft use to handle real-time data related to rides and driver locations? A) Amazon DynamoDB. B) Redis. C) Neo4j. D) MySQL. Show Answer Correct Answer: A) Amazon DynamoDB. 16. A health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' query criteria? A) >3. B) <3. C) <=3. D) >=3. Show Answer Correct Answer: D) >=3. 17. Which of the following is an example of markup languages? A) JavaScript. B) Python. C) HTML. D) PHP. Show Answer Correct Answer: C) HTML. 18. Define the term 'database'. A) A database is a collection of random files stored on a computer. B) A database is a type of software used for web browsing. C) A database is a physical location where data is kept. D) A database is an organized collection of structured data stored electronically. Show Answer Correct Answer: D) A database is an organized collection of structured data stored electronically. 19. ..... :Security, performance tuning, backup, recovery, and access control. A) DBA Responsibilities. B) Database Tables. C) SQL Queries. D) Data Models. Show Answer Correct Answer: A) DBA Responsibilities. 20. The three-schema architecture of a database consists of which of the following levels? A) Internal, External, and Conceptual. B) Physical, Logical, and Relational. C) System, User, and Administrator. D) Table, Row, and Column. Show Answer Correct Answer: A) Internal, External, and Conceptual. 21. What should you do if you are unsure how to resolve a data discrepancy? A) Contact medical staff to discuss the discrepancy. B) Ignore the discrepancy and continue with the process. C) Correct the data without consulting anyone. D) Delete the incorrect data from the system. Show Answer Correct Answer: A) Contact medical staff to discuss the discrepancy. 22. What happens if a database is poorly designed? A) Faster processing. B) Redundant data and poor decision-making. C) Easier backups. D) Improved queries. Show Answer Correct Answer: B) Redundant data and poor decision-making. 23. Which of the following is NOT a function of a Database Management System? A) Data storage, retrieval, and update. B) Data security and integrity management. C) Word processing and document editing. D) Backup and recovery management. Show Answer Correct Answer: C) Word processing and document editing. 24. Network databases are more common than hierarchical databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 25. In MS Access, a form is primarily used for: A) Entering and viewing data conveniently. B) Running background calculations. C) Deleting unwanted records. D) Creating relationships between tables. Show Answer Correct Answer: A) Entering and viewing data conveniently. ← 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