This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 10 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What action is necessary to resolve data discrepancies in healthcare? A) Wait for medical staff to see the error. B) Verify the data and consult with medical staff before correcting it. C) Ignore small errors because they do not affect patient care. D) Let automated systems correct the error. Show Answer Correct Answer: B) Verify the data and consult with medical staff before correcting it. 2. What is a weak entity? A) Is a composite entity. B) Is a strong entity. C) Cannot be identified uniquely. D) Has a primary key. Show Answer Correct Answer: C) Cannot be identified uniquely. 3. The ..... receives all application requests and translates them into the complex operations required to fulfill requests. A) Query. B) Workgroup. C) DBMS. D) DP. Show Answer Correct Answer: C) DBMS. 4. Which software tool in a DBMS provides an environment for developers to create and modify databases? A) Developer interface. B) Query processor. C) Data dictionary. D) Backup system. Show Answer Correct Answer: A) Developer interface. 5. .... store data in Single table. A) Flat File. B) Relational. C) Single File. D) One File. Show Answer Correct Answer: A) Flat File. 6. Which level of data independence deals with storage details? A) Physical. B) Logical. C) View. D) Conceptual. Show Answer Correct Answer: A) Physical. 7. What is data? A) Raw facts and figures B) Processed information C) A type of software D) A database structure A) E) A type of hardware. B) A) Raw facts and figures. C) G) A network protocol. D) F) A programming language. Show Answer Correct Answer: B) A) Raw facts and figures. 8. Sistem yang terdiri atas sekumpulan tabel data yang saling berhubungan dan sekumpulan program ( DBMS:Database Management System) yang memungkinkan berbagai user dan/atau program lain dapat mengakses dan memanipulasi tabel-tabel tersebut ..... A) Sistem Manajemen Informasi. B) Sistem Basis Data. C) Sistem Pengendalian Manajemen. D) Sistem Informasi Akuntansi. Show Answer Correct Answer: B) Sistem Basis Data. 9. What is a schema in a database? A) A schema is a collection of user data in a database. B) A schema is a type of database management system. C) A schema is a blueprint that defines the structure and organization of a database. D) A schema is a programming language for database queries. Show Answer Correct Answer: C) A schema is a blueprint that defines the structure and organization of a database. 10. A database is an organized collection of ..... A) Data. B) Attributes. C) Record. D) None of the above. Show Answer Correct Answer: A) Data. 11. What are the advantages of normalization? A) Slower query performance. B) Advantages of normalization include reduced data redundancy, improved data integrity, simplified data maintenance, enhanced query performance, and increased flexibility. C) Increased data duplication. D) Complicated data maintenance. Show Answer Correct Answer: B) Advantages of normalization include reduced data redundancy, improved data integrity, simplified data maintenance, enhanced query performance, and increased flexibility. 12. Which operation is used to retrieve data? A) INSERT. B) UPDATE. C) SELECT. D) DELETE. Show Answer Correct Answer: C) SELECT. 13. There can be multiple primary key in a table.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: B) B. False. 14. Explain the difference between primary key and foreign key. A) A primary key uniquely identifies a record in a table, while a foreign key links to a primary key in another table. B) A primary key can be duplicated across tables, while a foreign key cannot. C) A primary key is always a string, while a foreign key is always an integer. D) A primary key is used for indexing, while a foreign key is used for sorting records. Show Answer Correct Answer: A) A primary key uniquely identifies a record in a table, while a foreign key links to a primary key in another table. 15. What is data modeling used for? A) To show the data structure of a database. B) To compress the data. C) To encrypt the data. D) To store data in a single file. Show Answer Correct Answer: A) To show the data structure of a database. 16. Define a relational database. A) A relational database is a type of cloud storage service. B) A relational database is a database that organizes data into tables (relations) that can be linked-or related-based on data common to each. C) A relational database is a system that only stores images and videos. D) A relational database is a collection of unstructured data. Show Answer Correct Answer: B) A relational database is a database that organizes data into tables (relations) that can be linked-or related-based on data common to each. 17. SQL was officially standardized by ANSI in what year? A) 1970. B) 1979. C) 1986. D) 1995. Show Answer Correct Answer: C) 1986. 18. What is the function of the WHERE clause in SQL? A) To filter records based on a condition. B) To sort the results. C) To group records. D) To join tables. Show Answer Correct Answer: A) To filter records based on a condition. 19. Which technique manages concurrent access to prevent data inconsistencies? A) Time-stamping. B) Data validation. C) Locking. D) Format checking. Show Answer Correct Answer: C) Locking. 20. What is the significance of referential integrity? A) Referential integrity is only important for non-relational databases. B) Referential integrity is significant because it maintains data accuracy and consistency in relational databases. C) Referential integrity allows for faster data retrieval without any constraints. D) Referential integrity is a method for data encryption in databases. Show Answer Correct Answer: B) Referential integrity is significant because it maintains data accuracy and consistency in relational databases. 21. Which relational algebra operation is used to eliminate duplicate rows from a table? A) Union. B) Join. C) Project. D) Intersect. Show Answer Correct Answer: C) Project. 22. Cassandra is an example of a relational database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 23. ..... contains information that defines valid values that are stored in a column or data type. A) View. B) Rule. C) Index. D) Default. Show Answer Correct Answer: C) Index. 24. Which of the following operations is not a part of the CRUD operations in a DBMS? A) Create. B) Read. C) Update. D) Delete. E) Analyse. Show Answer Correct Answer: E) Analyse. 25. Name one characteristic of a modern DBMS. A) Support for data integrity and security features. B) No user access controls. C) Inability to handle large datasets. D) Limited support for data redundancy. Show Answer Correct Answer: A) Support for data integrity and security features. ← 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 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books