This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 6 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 6 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What type of devices do straight-through cables connect? A) Computer to computer without any connectivity device. B) Computer to switch. C) Switch to switch. D) Switch to hub. Show Answer Correct Answer: D) Switch to hub. 2. Which of the following is a Data Model? A) Entity-Relationship model. B) Relational data model. C) Object-Based data model. D) All of the above. Show Answer Correct Answer: D) All of the above. 3. What does the Details view control allow a user to do? A) Edit the database structure. B) Create new database tables. C) View multiple rows at once. D) See one row at a time. Show Answer Correct Answer: D) See one row at a time. 4. 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) A collection of related data. B) A collection of unrelated data. C) A web development framework. D) A type of hardware. Show Answer Correct Answer: A) A) A collection of related data. 5. .... are dedicated computers that hold the actual databases and run only DBMS and related Software. A) Main Server. B) Web Server. C) Database Server. D) Non Database Server. Show Answer Correct Answer: C) Database Server. 6. 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) Database Systems. B) Database. C) Komponen Dasar dari Sistem Database. D) Sistem Informasi Akuntansi. Show Answer Correct Answer: B) Database. 7. The content of any given field is the ..... A) Database. B) Field value. C) Entity. D) Table. Show Answer Correct Answer: B) Field value. 8. 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. 9. A ..... in a table represents a relationship among a set of values A) Field. B) Foreign key. C) Record. D) Primary key. Show Answer Correct Answer: C) Record. 10. 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. 11. 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. 12. What is the cost associated with using a DBMS? A) No recurrent annual maintenance cost. B) Additional hardware costs. C) Decreased cost of conversion. D) Lower maintenance costs. Show Answer Correct Answer: B) Additional hardware costs. 13. Which of the following is a characteristic of a NoSQL database? A) Support for unstructured data. B) Fixed schema. C) ACID transactions. D) Relational data model. Show Answer Correct Answer: A) Support for unstructured data. 14. What is the main goal of relational database design? A) To simplify queries. B) To create complex schemas. C) To avoid redundant data. D) To increase data size. Show Answer Correct Answer: C) To avoid redundant data. 15. Who introduced the relational database model? A) Donald Chamberlin. B) Raymond Boyce. C) Edgar F. Codd. D) Larry Ellison. Show Answer Correct Answer: C) Edgar F. Codd. 16. 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. 17. 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. 18. 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. 19. 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. 20. What is the main function of an index in a database? A) To create backups of data. B) To manage user access. C) To speed up data retrieval. D) To store data securely. Show Answer Correct Answer: C) To speed up data retrieval. 21. Define ACID properties in the context of transactions. A) Atomicity, Clarity, Isolation, Durability. B) Accuracy, Consistency, Isolation, Durability. C) Atomicity, Consistency, Isolation, Reliability. D) ACID properties:Atomicity, Consistency, Isolation, Durability. Show Answer Correct Answer: D) ACID properties:Atomicity, Consistency, Isolation, Durability. 22. Which of the following is a disadvantage of DBMS? A) High speed. B) Complexity. C) Data redundancy. D) Low memory usage. Show Answer Correct Answer: B) Complexity. 23. 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. 24. 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. 25. What is the purpose of the COMMIT command in SQL? A) To save changes made during a transaction. B) To create a new database. C) To delete all records from a table. D) To retrieve data from a table. Show Answer Correct Answer: A) To save changes made during a transaction. ← 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 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 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books