This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 19 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 19 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In tables, data is organized in the form of rows and columns.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: A) A. True. 2. Which of the following is an example of a Database Management System? A) Microsoft Word. B) Adobe Photoshop. C) MySQL. D) Google Chrome. Show Answer Correct Answer: C) MySQL. 3. Deadlock Resolution: ..... one transaction to break a deadlock. A) Aborting. B) Committing. C) Locking. D) Suspending. Show Answer Correct Answer: A) Aborting. 4. What is the function of a surrogate key? A) To create indexes. B) To store user data. C) To link multiple tables. D) To replace a natural key. Show Answer Correct Answer: D) To replace a natural key. 5. Which SQL clause is used to group rows that have the same values in specified columns? A) GROUP BY. B) ORDER BY. C) HAVING. D) SELECT. Show Answer Correct Answer: A) GROUP BY. 6. Which SQL command is used to create a new table in a database? A) INSERT. B) ALTER. C) CREATE TABLE. D) DROP TABLE. Show Answer Correct Answer: C) CREATE TABLE. 7. What is the primary key in the following relation? STUDENT(StudentID, Name, Address, CourseID) A) StudentID. B) Name. C) Address. D) CourseID. Show Answer Correct Answer: A) StudentID. 8. Which of the following is NOT a characteristic of Object-Oriented Database Management Systems (OODBMS)? A) Data stored in tables. B) Supports complex data types. C) Data represented as objects. D) Integration with object-oriented programming. Show Answer Correct Answer: A) Data stored in tables. 9. What is the purpose of the COMMIT command? A) To permanently save all changes made in a transaction. B) To undo changes made in a transaction. C) To delete a record. D) To create a new table. Show Answer Correct Answer: A) To permanently save all changes made in a transaction. 10. What do foreign keys do? A) They only store numbers. B) They establish relationships between tables. C) They create new tables. D) They delete records. Show Answer Correct Answer: B) They establish relationships between tables. 11. What is a JOIN operation in SQL and why is it used? A) A JOIN operation in SQL is used to delete rows from a table. B) A JOIN operation in SQL is used to create new tables from existing ones. C) A JOIN operation in SQL is used to combine rows from two or more tables based on a related column. D) A JOIN operation in SQL is used to sort data within a single table. Show Answer Correct Answer: C) A JOIN operation in SQL is used to combine rows from two or more tables based on a related column. 12. What are the advantages of using a DBMS? A) Higher maintenance costs. B) Limited user access. C) Advantages of using a DBMS include data integrity, security, efficient management, reduced redundancy, and improved access. D) Increased data duplication. Show Answer Correct Answer: C) Advantages of using a DBMS include data integrity, security, efficient management, reduced redundancy, and improved access. 13. What is a feature of files regarding data storage? A) Multiple CSVs stored in different folders. B) All data in one table. C) Automatic backups. D) Role-based access. Show Answer Correct Answer: A) Multiple CSVs stored in different folders. 14. Which of the following defines the term 'field' in relation to databases? A) A field is all of the information about one person or one thing. B) A field is the collection of all the database records on one topic or subject. C) A field is one type or piece of information. D) None of the above. Show Answer Correct Answer: C) A field is one type or piece of information. 15. Every row in a table has the same structure.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: A) A. True. 16. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database? A) DDL. B) DML. C) DCL. D) SCHEMA. Show Answer Correct Answer: B) DML. 17. Which SQL command is part of DDL? A) SELECT. B) UPDATE. C) CREATE TABLE. D) GRANT. Show Answer Correct Answer: C) CREATE TABLE. 18. Which of the following products do not provide an enterprise database? A) MS Access. B) MS SQL Server. C) IBM DB2. D) Oracle RDBMS. Show Answer Correct Answer: A) MS Access. 19. Which one of these cannot be taken as a primary key? A) ID. B) Registration no. C) Department ID. D) Street. Show Answer Correct Answer: D) Street. 20. Name the first normal form (1NF) requirement. A) There must be a primary key for each table. B) Attributes can contain multiple values. C) All attributes must be unique. D) All attributes must contain atomic values. Show Answer Correct Answer: D) All attributes must contain atomic values. 21. What does the term 'cardinality' refer to? A) Number of entities. B) Number of relationships. C) Number of tables. D) Number of attributes. Show Answer Correct Answer: A) Number of entities. 22. Define normalization in the context of databases. A) Normalization is the method of encrypting data for security purposes. B) Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. C) Normalization refers to the process of backing up data in a database. D) Normalization is the technique of merging multiple databases into one. Show Answer Correct Answer: B) Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. 23. Which of the following commands is used to modify the structure of an existing table? A) ALTER TABLE. B) MODIFY TABLE. C) CHANGE TABLE. D) UPDATE TABLE. Show Answer Correct Answer: A) ALTER TABLE. 24. Process Failure:Failure that causes loss of memory but not ..... data. A) Disk. B) Network. C) Cache. D) Register. Show Answer Correct Answer: A) Disk. 25. What is the purpose of backing up a database? A) To delete unnecessary data. B) To ensure data can be restored in case of loss. C) To improve data access speed. D) To create new user accounts. Show Answer Correct Answer: B) To ensure data can be restored in case of loss. ← 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