This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 3 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 3 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a database? A) A collection of related data B) A type of computer C) A programming language D) A software application A) A web development framework. B) A type of hardware. C) A) A collection of related data. D) A collection of unrelated data. Show Answer Correct Answer: C) A) A collection of related data. 2. .... are dedicated computers that hold the actual databases and run only DBMS and related Software. A) Web Server. B) Non Database Server. C) Main Server. D) Database Server. Show Answer Correct Answer: D) Database Server. 3. Suatu susunan/kumpulan data operasional lengkap dari suatu organisasi/perusahaan yang diorganisir/dikelola dan simpan secara terintegrasi dengan menggunakan metode tertentu dengan menggunakan komputer sehingga mampu menyediakan informasi yang diperlukan pemakainya. A) Sistem Informasi Akuntansi. B) Database Systems. C) Database. D) Komponen Dasar dari Sistem Database. Show Answer Correct Answer: C) Database. 4. The content of any given field is the ..... A) Entity. B) Field value. C) Table. D) Database. Show Answer Correct Answer: B) Field value. 5. Explain the concept of grouping and ungrouping in relational algebra. A) Grouping separates data into distinct categories, while ungrouping combines them into one. B) Grouping is used to delete data, while ungrouping is used to create new data. C) Grouping and ungrouping are processes that only apply to numerical data. D) Grouping aggregates data based on attributes, while ungrouping reverses this aggregation. Show Answer Correct Answer: D) Grouping aggregates data based on attributes, while ungrouping reverses this aggregation. 6. A ..... in a table represents a relationship among a set of values A) Field. B) Record. C) Foreign key. D) Primary key. Show Answer Correct Answer: B) Record. 7. What is the main function of a Database Management System (DBMS)? A) To manage and organize data efficiently. B) To store files in a directory system. C) To delete redundant data automatically. D) To generate reports only. Show Answer Correct Answer: A) To manage and organize data efficiently. 8. Specialization is the reverse of generalization. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 9. What is the cost associated with using a DBMS? A) Lower maintenance costs. B) Additional hardware costs. C) No recurrent annual maintenance cost. D) Decreased cost of conversion. Show Answer Correct Answer: B) Additional hardware costs. 10. Which of the following is a characteristic of a NoSQL database? A) Relational data model. B) Support for unstructured data. C) ACID transactions. D) Fixed schema. Show Answer Correct Answer: B) Support for unstructured data. 11. What is the main goal of relational database design? A) To create complex schemas. B) To avoid redundant data. C) To simplify queries. D) To increase data size. Show Answer Correct Answer: B) To avoid redundant data. 12. Who introduced the relational database model? A) Larry Ellison. B) Raymond Boyce. C) Donald Chamberlin. D) Edgar F. Codd. Show Answer Correct Answer: D) Edgar F. Codd. 13. A primary key in a database is used to: A) Encrypt the data. B) Uniquely identify each record in a table. C) Link two databases. D) Sort records alphabetically. Show Answer Correct Answer: B) Uniquely identify each record in a table. 14. A DBMS can improve the efficiency of data management in an organization by: A) Allowing multiple users to access and manage data according to their needs, integrating different views, and enabling sharing among applications. B) Storing data in a single file and preventing access from multiple users. C) Encrypting all data and restricting access to only one administrator. D) Automatically deleting old data to free up space. Show Answer Correct Answer: A) Allowing multiple users to access and manage data according to their needs, integrating different views, and enabling sharing among applications. 15. Which DBMS function is responsible for providing backup and data recovery procedures? A) Backup and recovery management. B) Data mining. C) Transaction processing. D) Query optimization. Show Answer Correct Answer: A) Backup and recovery management. 16. Which of the following describes the physical level of data abstraction? A) Data relationships. B) How data is actually stored. C) What data is stored. D) User interface design. Show Answer Correct Answer: B) How data is actually stored. 17. What is the main function of an index in a database? A) To create backups of data. B) To speed up data retrieval. C) To store data securely. D) To manage user access. Show Answer Correct Answer: B) To speed up data retrieval. 18. Define ACID properties in the context of transactions. A) ACID properties:Atomicity, Consistency, Isolation, Durability. B) Atomicity, Consistency, Isolation, Reliability. C) Accuracy, Consistency, Isolation, Durability. D) Atomicity, Clarity, Isolation, Durability. Show Answer Correct Answer: A) ACID properties:Atomicity, Consistency, Isolation, Durability. 19. Which of the following is a disadvantage of DBMS? A) High speed. B) Data redundancy. C) Low memory usage. D) Complexity. Show Answer Correct Answer: D) Complexity. 20. What is a key challenge in distributed database architectures? A) Ensuring all data in the distributed databases are consistent and concurrently updated. B) Reducing the number of users. C) Limiting data to a single site. D) Preventing any data replication. Show Answer Correct Answer: A) Ensuring all data in the distributed databases are consistent and concurrently updated. 21. Which one of the following statements selects the correct one about the process and tread states? A) Both process state and treads are active (running) at a time. B) All threads cannot access every address in the task. C) Both process state and treads do not share CPU. D) Both process state and treads share CPU. Show Answer Correct Answer: D) Both process state and treads share CPU. 22. What is the purpose of indexing in SQL databases? A) To ensure data integrity. B) To increase the size of the database. C) The purpose of indexing in SQL databases is to speed up data retrieval. D) To create backups of the database. Show Answer Correct Answer: C) The purpose of indexing in SQL databases is to speed up data retrieval. 23. 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. 24. 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. 25. What is the purpose of the DISTINCT keyword? A) To count duplicates. B) To remove duplicates. C) To sort data. D) To group data. Show Answer Correct Answer: B) To remove duplicates. 26. Explain the concept of generalization in the Extended ER Model. A) Generalization is the process of creating a super-entity from multiple entities that share common attributes in the Extended ER Model. B) Generalization is the process of merging two unrelated entities into one. C) Generalization involves creating multiple sub-entities from a single entity. D) Generalization is the technique of deleting attributes from an entity in the Extended ER Model. Show Answer Correct Answer: A) Generalization is the process of creating a super-entity from multiple entities that share common attributes in the Extended ER Model. 27. 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. 28. 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. 29. 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. 30. Which of the following is a generic entity type that has a relationship with one or more subtypes? A) Supertype. B) Class. C) Megatype. D) Subgroup. Show Answer Correct Answer: A) Supertype. 31. 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;. 32. Which of the following refers to the level of data abstraction that describes exactly how the data actually stored? A) Conceptual Level. B) Logical Level. C) File Level. D) Physical Level. Show Answer Correct Answer: D) Physical Level. 33. A desktop database is best described as: A) A database used only for mobile devices. B) A cloud-based database accessible from anywhere. C) A multiuser database running on a server. D) A single-user database running on a personal computer. Show Answer Correct Answer: D) A single-user database running on a personal computer. 34. Which company uses Redis as a caching layer to improve performance? A) Facebook. B) Twitter. C) Square. D) NASA. Show Answer Correct Answer: B) Twitter. 35. 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 create backups of the database. D) To enforce data integrity. Show Answer Correct Answer: A) To provide a virtual table based on a query. 36. The three levels of the DBMS architecture are: A) Physical, Conceptual, External. B) Client, Server, Cloud. C) Physical, Logical, Relational. D) Schema, Instance, Data. Show Answer Correct Answer: A) Physical, Conceptual, External. 37. 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. 38. Components of database environment A) Software, Data, Procedure, People. B) Hardware, Software, Procedure, People. C) Hardware, Software, Data, Procedure, People. D) Hardware, Software, Data, Procedure. Show Answer Correct Answer: C) Hardware, Software, Data, Procedure, People. 39. Which clause is used in SQL to limit the number of rows returned? A) TOP / LIMIT. B) END. C) STOP. D) ROWNUMBER. Show Answer Correct Answer: A) TOP / LIMIT. 40. Which data link layer device is used to prepare a MAC table and send packets for the selected device only? A) Router. B) Switch. C) Repeater. D) Bridge. Show Answer Correct Answer: B) Switch. 41. 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;. 42. 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. 43. What does the select operation do in relational algebra? A) Combines tables. B) Retrieves specific records. C) Updates records. D) Deletes records. Show Answer Correct Answer: B) Retrieves specific records. 44. Which of the following is an issue in file processing systems? A) Data clarity. B) Data organization. C) Data simplicity. D) Data redundancy. Show Answer Correct Answer: D) Data redundancy. 45. What are primary keys and foreign keys? A) Foreign keys are always numeric values. B) Primary keys are used for indexing data only. C) Primary keys can be duplicated across tables. D) Primary keys uniquely identify records in a table, while foreign keys create relationships between tables by referencing primary keys. Show Answer Correct Answer: D) Primary keys uniquely identify records in a table, while foreign keys create relationships between tables by referencing primary keys. 46. The term attribute refers to a ..... of a table. A) Key. B) Record. C) Tuple. D) Column. Show Answer Correct Answer: D) Column. 47. In a ..... clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers. A) Straight. B) Continuous. C) Dense. D) Sparse. Show Answer Correct Answer: C) Dense. 48. Which database view is used by users who input and view data? A) Physical view. B) Logical view. C) User view. D) None of the above. Show Answer Correct Answer: C) User view. 49. The number of attributes in a relation is called its: A) Tuple. B) Degree. C) Entity. D) Cardinality. Show Answer Correct Answer: B) Degree. 50. What is the primary purpose of a supertype/subtype relationship in an ERD? A) To normalize the database. B) To define unique keys. C) To handle data redundancy. D) To represent inheritance among entities. Show Answer Correct Answer: D) To represent inheritance among entities. 51. ..... :Protecting data by making it unreadable. A) Authentication. B) Encryption. C) Compression. D) Decryption. Show Answer Correct Answer: B) Encryption. 52. Which is correct for an Online Shop ERD? A) Order-One-to-One-Product. B) Product-Recursive. C) Customer-One-to-One-Order. D) Customer-Many-to-Many-Product (through Orders). Show Answer Correct Answer: D) Customer-Many-to-Many-Product (through Orders). 53. In a library system, a Book can be borrowed many times, and a Borrower can borrow many Books. What type of relationship best describes the connection between Book and Borrower? A) Many-to-Many. B) One-to-Many. C) Recursive. D) One-to-One. Show Answer Correct Answer: A) Many-to-Many. 54. What does a NULL constraint in SQL specify? A) The column can have empty values. B) The column cannot have duplicate values. C) The column must always have a numeric value. D) The column must not have any value. Show Answer Correct Answer: A) The column can have empty values. 55. What are the different normal forms in normalization? A) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. B) 1NF+, 2NF+, 3NF+, 4NF+, 5NF+. C) 1NF, 2NF, 3NF, 4NF, 6NF. D) 1NF, 2NF, 3NF, 4NF, 5NF, 6NF. Show Answer Correct Answer: A) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. 56. Which of the following is NOT typically managed by a Database Management System (DBMS)? A) Transaction Manager. B) Query Manager. C) Internet Browsing History. D) Storage Manager. Show Answer Correct Answer: C) Internet Browsing History. 57. What is a feature of files regarding layout? A) They require a server. B) They are always encrypted. C) Everyone uses the same flat layout. D) They support complex queries. Show Answer Correct Answer: C) Everyone uses the same flat layout. 58. What does the term 'data independence' refer to? A) The ability to access data from multiple sources. B) The ability to store data in different formats. C) The ability to secure data from unauthorized access. D) The ability to change data without affecting applications. Show Answer Correct Answer: D) The ability to change data without affecting applications. 59. Which validation rule accepts only a-z letters for fields in Access? A) Is null or NOT like "*[! a-z]*". B) Is null or NOT like "*![a-z]*". C) Is null or NOT like "*[a-z ]*". D) Is null or NOT like "[! a-z]". Show Answer Correct Answer: A) Is null or NOT like "*[! a-z]*". 60. Primary key does allow the Null Values, whereas in Unique key doesn't accept the Null values . True or False? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. ← PreviousNext →Related QuizzesScience QuizzesClass 12 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 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books