This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 7 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 7 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of indexing in SQL databases? A) To create backups of the database. B) To ensure data integrity. C) To increase the size of the database. D) The purpose of indexing in SQL databases is to speed up data retrieval. Show Answer Correct Answer: D) The purpose of indexing in SQL databases is to speed up data retrieval. 2. What should be done if a data entry error is discovered in a patient's record? A) Delete the entire record to avoid confusion. B) Consult with the relevant department to correct the error. C) Ignore the error and continue with the process. D) Share the error with all departments for greater transparency. Show Answer Correct Answer: B) Consult with the relevant department to correct the error. 3. What is a derived attribute? A) An attribute that is mandatory. B) An attribute that is calculated. C) An attribute that exists physically. D) An attribute that is optional. Show Answer Correct Answer: B) An attribute that is calculated. 4. What is the purpose of the DISTINCT keyword? A) To remove duplicates. B) To count duplicates. C) To sort data. D) To group data. Show Answer Correct Answer: A) To remove duplicates. 5. Explain the concept of generalization in the Extended ER Model. A) Generalization is the technique of deleting attributes from an entity in the Extended ER Model. B) Generalization is the process of creating a super-entity from multiple entities that share common attributes in the Extended ER Model. C) Generalization involves creating multiple sub-entities from a single entity. D) Generalization is the process of merging two unrelated entities into one. Show Answer Correct Answer: B) Generalization is the process of creating a super-entity from multiple entities that share common attributes in the Extended ER Model. 6. What is the difference between a clustered and a non-clustered index? A) A non-clustered index stores data in the same order as the table rows. B) A clustered index can be created on multiple columns at once. C) A clustered index sorts and stores the data rows in the table based on the index key, while a non-clustered index creates a separate structure that references the data rows. D) A clustered index is always faster than a non-clustered index. Show Answer Correct Answer: C) A clustered index sorts and stores the data rows in the table based on the index key, while a non-clustered index creates a separate structure that references the data rows. 7. What role does a database administrator play in managing a DBMS? A) The DBA focuses solely on data entry tasks. B) The DBA manages the DBMS by overseeing its installation, maintenance, security, performance, and user access. C) The DBA is responsible for developing new software applications. D) The DBA only handles user complaints about the DBMS. Show Answer Correct Answer: B) The DBA manages the DBMS by overseeing its installation, maintenance, security, performance, and user access. 8. Which of the following is a tool to store, edit and organise data in a database? A) A database. B) A DBMS. C) SQL. D) None of the above. Show Answer Correct Answer: B) A DBMS. 9. Which of the following is a generic entity type that has a relationship with one or more subtypes? A) Megatype. B) Supertype. C) Subgroup. D) Class. Show Answer Correct Answer: B) Supertype. 10. Write a basic SQL query to select all records from a table. A) GET * FROM table name;. B) SELECT * FROM table name;. C) FETCH * FROM table name;. D) SELECT ALL FROM table name;. Show Answer Correct Answer: B) SELECT * FROM table name;. 11. Which of the following refers to the level of data abstraction that describes exactly how the data actually stored? A) Conceptual Level. B) Physical Level. C) File Level. D) Logical Level. Show Answer Correct Answer: B) Physical Level. 12. A desktop database is best described as: A) A multiuser database running on a server. B) A single-user database running on a personal computer. C) A cloud-based database accessible from anywhere. D) A database used only for mobile devices. Show Answer Correct Answer: B) A single-user database running on a personal computer. 13. Which company uses Redis as a caching layer to improve performance? A) Facebook. B) Twitter. C) NASA. D) Square. Show Answer Correct Answer: B) Twitter. 14. What is the function of a view in a database? A) To provide a virtual table based on a query. B) To store data permanently. C) To enforce data integrity. D) To create backups of the database. Show Answer Correct Answer: A) To provide a virtual table based on a query. 15. The three levels of the DBMS architecture are: A) Physical, Conceptual, External. B) Physical, Logical, Relational. C) Schema, Instance, Data. D) Client, Server, Cloud. Show Answer Correct Answer: A) Physical, Conceptual, External. 16. In RDBMS, data is organized in the form of ..... A) Table. B) Record. C) Field. D) None of the above. Show Answer Correct Answer: A) Table. 17. Components of database environment A) Hardware, Software, Procedure, People. B) Hardware, Software, Data, Procedure, People. C) Software, Data, Procedure, People. D) Hardware, Software, Data, Procedure. Show Answer Correct Answer: B) Hardware, Software, Data, Procedure, People. 18. Which clause is used in SQL to limit the number of rows returned? A) TOP / LIMIT. B) STOP. C) END. D) ROWNUMBER. Show Answer Correct Answer: A) TOP / LIMIT. 19. Which data link layer device is used to prepare a MAC table and send packets for the selected device only? A) Switch. B) Router. C) Bridge. D) Repeater. Show Answer Correct Answer: A) Switch. 20. Hey there, future data wizard! Imagine you're in a classroom with NURSHAIMA, NUR AQILAH and ATIQAH BASHASH, and your task is to pull up all the records from the 'Students' table. Can you write the magic SQL spell to do that? A) GET * FROM Students;. B) SELECT ALL FROM Students;. C) SELECT Students;. D) SELECT * FROM Students;. Show Answer Correct Answer: D) SELECT * FROM Students;. 21. While inserting the record into the index, if the search-key value does not appear in the index. A) The system adds a pointer to the new record in the index entry. B) The system places the record being inserted after the other records with the same search-key values. C) The system inserts an index entry with the search-key value in the index at the appropriate position. D) None of the mentioned. Show Answer Correct Answer: C) The system inserts an index entry with the search-key value in the index at the appropriate position. 22. What does the select operation do in relational algebra? A) Retrieves specific records. B) Combines tables. C) Updates records. D) Deletes records. Show Answer Correct Answer: A) Retrieves specific records. 23. Which of the following is an issue in file processing systems? A) Data simplicity. B) Data organization. C) Data clarity. D) Data redundancy. Show Answer Correct Answer: D) Data redundancy. 24. What are primary keys and foreign keys? A) Primary keys uniquely identify records in a table, while foreign keys create relationships between tables by referencing primary keys. B) Primary keys can be duplicated across tables. C) Primary keys are used for indexing data only. D) Foreign keys are always numeric values. Show Answer Correct Answer: A) Primary keys uniquely identify records in a table, while foreign keys create relationships between tables by referencing primary keys. 25. The term attribute refers to a ..... of a table. A) Record. B) Column. C) Tuple. D) Key. Show Answer Correct Answer: B) Column. ← 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 8Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books