This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 4 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 4 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which DBMS does Snapchat use for high-performance data handling? A) Redis. B) Google Cloud Spanner. C) Cassandra. D) Oracle Database. Show Answer Correct Answer: B) Google Cloud Spanner. 2. Kemampuan untuk memodifikasi skema di satu level tanpa mengubah skema di level selanjutnya yang lebih tinggi. A) Kompetensi Data. B) Independensi Data. C) Komitmen Data. D) Irasional Data. Show Answer Correct Answer: B) Independensi Data. 3. What is the main purpose of database prototyping? A) Reduce hardware cost. B) Improve user feedback early. C) Replace DBMS. D) Eliminate database design. Show Answer Correct Answer: B) Improve user feedback early. 4. What is the purpose of a composite key in a database? A) To store large amounts of data. B) To uniquely identify a record using multiple attributes. C) To link two tables together. D) To enforce data integrity. Show Answer Correct Answer: B) To uniquely identify a record using multiple attributes. 5. What is the primary purpose of a DBMS? A) To perform complex calculations on data. B) To create user interfaces for applications. C) To store, retrieve, and manage data in databases. D) To ensure data is visually appealing. Show Answer Correct Answer: C) To store, retrieve, and manage data in databases. 6. A database management system (DBMS) is primarily used to: A) Design websites. B) Store, organize, and manage data efficiently. C) Write programming languages. D) Create animations. Show Answer Correct Answer: B) Store, organize, and manage data efficiently. 7. Identify the procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released? A) Two phase lock. B) Authorization rule. C) Record controller. D) Exclusive lock. Show Answer Correct Answer: A) Two phase lock. 8. Which of the following protocols ensures conflict serializability and safety from deadlocks? A) Two-phase locking protocol. B) Time-stamp ordering protocol. C) Graph based protocol. D) None of the mentioned. Show Answer Correct Answer: B) Time-stamp ordering protocol. 9. Which advantage of DBMS directly contributes to making better business decisions? A) Better data integration. B) Improved data security. C) Improved decision making. D) Minimized data inconsistency. Show Answer Correct Answer: C) Improved decision making. 10. Which of the following query is correct for using comparison operators in SQL? A) SELECT sname, coursename FROM studentinfo WHERE age>50 and <80;. B) SELECT sname, coursename FROM studentinfo WHERE age>50 and age <80;. C) SELECT sname, coursename FROM studentinfo WHERE age>50 and WHERE age<80;. D) None of the above. Show Answer Correct Answer: B) SELECT sname, coursename FROM studentinfo WHERE age>50 and age <80;. 11. Which view is used to arrange table data in different graphical layouts to summarize data? A) Data sheet view. B) Table view. C) Design view. D) Pivot chart view. Show Answer Correct Answer: D) Pivot chart view. 12. What are the techniques of managing concurrency control? A) Locking, Time-stamping, Multi-version Concurrency Control. B) Time-stamping, Data Validation, Data Verification. C) Locking, Data Verification, Multi-version Concurrency Control. D) Locking, Time-stamping, Data Validation. Show Answer Correct Answer: A) Locking, Time-stamping, Multi-version Concurrency Control. 13. What type of relationship involves two entities? A) N-array. B) Binary. C) Ternary. D) Unary. Show Answer Correct Answer: B) Binary. 14. What is a stored procedure in SQL? A) A stored procedure is a type of index that speeds up data retrieval. B) A stored procedure is a command used to delete records. C) A stored procedure is a method for aggregating data. D) A stored procedure is a set of SQL statements that can be stored and executed as a single unit. Show Answer Correct Answer: D) A stored procedure is a set of SQL statements that can be stored and executed as a single unit. 15. Which of the following describes a weak entity? A) An entity that has a strong relationship. B) An entity with a primary key. C) An entity that cannot be uniquely identified. D) An entity with multiple attributes. Show Answer Correct Answer: C) An entity that cannot be uniquely identified. 16. How can indexing improve SQL query performance? A) Indexing improves SQL query performance by allowing faster data retrieval through optimized data structures. B) Indexing complicates data structures, making queries more complex. C) Indexing has no effect on SQL query performance or efficiency. D) Indexing slows down data retrieval by creating additional overhead. Show Answer Correct Answer: A) Indexing improves SQL query performance by allowing faster data retrieval through optimized data structures. 17. The process of ensuring that the database reflects all real-world changes is called: A) Data redundancy. B) Data abstraction. C) Data persistence. D) Data recovery. Show Answer Correct Answer: C) Data persistence. 18. Explain the difference between relations and attributes. A) Relations are tables; attributes are columns in those tables. B) Attributes are tables; relations are columns in those tables. C) Relations are the same as attributes. D) Relations refer to the data type of a column. Show Answer Correct Answer: A) Relations are tables; attributes are columns in those tables. 19. A NULL value is treated as a blank or 0. A) True. B) False. C) None of the above. D) None of the above. Show Answer Correct Answer: B) False. 20. An ..... consists of a search-key value and pointers to one or more records with that value as their search-key value. A) Index entry. B) Index map. C) Index cluster. D) Index hash. Show Answer Correct Answer: A) Index entry. 21. Suppose a banking system has a Transactions table. To ensure that withdrawals do not exceed available balance, which database constraint should be applied? A) FOREIGN KEY. B) UNIQUE. C) CHECK. D) NOT NULL. Show Answer Correct Answer: C) CHECK. 22. What is a potential issue with the greater impact of a failure in a DBMS? A) Minimal disruption to operations. B) Reduced vulnerability of the system. C) Decreased reliance on the DBMS. D) Halt in operations due to component failure. Show Answer Correct Answer: D) Halt in operations due to component failure. 23. What type of data independence is the ability to modify logical or conceptual schema without changing the external schemas or application programs? A) Physical Data Independence. B) Logical Data Independence. C) All the above. D) None of the above. Show Answer Correct Answer: B) Logical Data Independence. 24. What is an advantage of file-based systems? A) Simplicity B) High security C) Easy to scale D) Automatic backups A) Difficult to manage. B) A) Simplicity. C) Complexity. D) Limited access. Show Answer Correct Answer: B) A) Simplicity. 25. Which department is most likely to be consulted to resolve a data discrepancy? A) Security Team. B) Marketing. C) Health Information Management. D) Maintenance. Show Answer Correct Answer: C) Health Information Management. 26. What does a schema diagram visually represent? A) Database operations. B) Table structures and their relationships. C) SQL queries. D) Database security measures. Show Answer Correct Answer: B) Table structures and their relationships. 27. What is the role of procedures in a database system? A) To store data. B) To enforce standards. C) To manage hardware. D) To design the database. Show Answer Correct Answer: B) To enforce standards. 28. ..... :Automates deployment and system operations. A) Database. B) Frontend. C) Networking. D) DevOps. Show Answer Correct Answer: D) DevOps. 29. What is the significance of primary keys in the relational model? A) They uniquely identify a record in a table. B) They allow null values in a table. C) They are used for encryption. D) They define the physical storage structure of the database. Show Answer Correct Answer: A) They uniquely identify a record in a table. 30. The ..... refers to the way data is organized in and accessible from DBMS. A) Database hierarchy. B) Data model. C) Data sharing. D) Database organization. Show Answer Correct Answer: B) Data model. 31. What does ACID stand for in database management? A) Atomicity, Consistency, Isolation, Durability. B) Atomicity, Concurrency, Isolation, Durability. C) Atomicity, Consistency, Integration, Durability. D) Addition, Consistency, Isolation, Durability. Show Answer Correct Answer: A) Atomicity, Consistency, Isolation, Durability. 32. What is a file-based data management system? A) A type of software that allows users to access and organize small groups of data. B) A software application through which a user interacts with a database. C) A collection of data related in a logical manner. D) A system which allows users to have complete control over the DB. Show Answer Correct Answer: A) A type of software that allows users to access and organize small groups of data. 33. What is the main function of a database management system in a hospital? A) Automate all medical procedures. B) Provide a centralized system to store and retrieve patient data. C) Allow unrestricted access to patient records. D) Replace healthcare professionals. Show Answer Correct Answer: B) Provide a centralized system to store and retrieve patient data. 34. Which normal form removes partial dependency? A) 2NF. B) BCNF. C) 1NF. D) 3NF. Show Answer Correct Answer: A) 2NF. 35. 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. 36. What is a weak entity? A) Cannot be identified uniquely. B) Has a primary key. C) Is a composite entity. D) Is a strong entity. Show Answer Correct Answer: A) Cannot be identified uniquely. 37. The ..... receives all application requests and translates them into the complex operations required to fulfill requests. A) DP. B) Query. C) DBMS. D) Workgroup. Show Answer Correct Answer: C) DBMS. 38. Which software tool in a DBMS provides an environment for developers to create and modify databases? A) Developer interface. B) Query processor. C) Backup system. D) Data dictionary. Show Answer Correct Answer: A) Developer interface. 39. .... store data in Single table. A) Relational. B) One File. C) Flat File. D) Single File. Show Answer Correct Answer: C) Flat File. 40. Which level of data independence deals with storage details? A) Logical. B) Physical. C) Conceptual. D) View. Show Answer Correct Answer: B) Physical. 41. 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. 42. 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 Pengendalian Manajemen. B) Sistem Manajemen Informasi. C) Sistem Informasi Akuntansi. D) Sistem Basis Data. Show Answer Correct Answer: D) Sistem Basis Data. 43. A database is an organized collection of ..... A) Data. B) Attributes. C) Record. D) None of the above. Show Answer Correct Answer: A) Data. 44. 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. 45. Which operation is used to retrieve data? A) DELETE. B) SELECT. C) UPDATE. D) INSERT. Show Answer Correct Answer: B) SELECT. 46. 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. 47. Explain the difference between primary key and foreign key. A) A primary key is used for indexing, while a foreign key is used for sorting records. B) A primary key is always a string, while a foreign key is always an integer. C) A primary key uniquely identifies a record in a table, while a foreign key links to a primary key in another table. D) A primary key can be duplicated across tables, while a foreign key cannot. Show Answer Correct Answer: C) A primary key uniquely identifies a record in a table, while a foreign key links to a primary key in another table. 48. What is data modeling used for? A) To show the data structure of a database. B) To store data in a single file. C) To compress the data. D) To encrypt the data. Show Answer Correct Answer: A) To show the data structure of a database. 49. 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. 50. SQL was officially standardized by ANSI in what year? A) 1970. B) 1986. C) 1995. D) 1979. Show Answer Correct Answer: B) 1986. 51. What is the function of the WHERE clause in SQL? A) To join tables. B) To sort the results. C) To filter records based on a condition. D) To group records. Show Answer Correct Answer: C) To filter records based on a condition. 52. Which technique manages concurrent access to prevent data inconsistencies? A) Time-stamping. B) Locking. C) Format checking. D) Data validation. Show Answer Correct Answer: B) Locking. 53. 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. 54. Which relational algebra operation is used to eliminate duplicate rows from a table? A) Union. B) Intersect. C) Project. D) Join. Show Answer Correct Answer: C) Project. 55. 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. 56. ..... contains information that defines valid values that are stored in a column or data type. A) Index. B) Rule. C) View. D) Default. Show Answer Correct Answer: A) Index. 57. Which of the following operations is not a part of the CRUD operations in a DBMS? A) Update. B) Analyse. C) Delete. D) Read. E) Create. Show Answer Correct Answer: B) Analyse. 58. 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. 59. .... are the basic building blocks of a database. A) Tables. B) Record. C) Fields. D) All of the above. Show Answer Correct Answer: A) Tables. 60. List different types of distributed data DBMS architectures A) The different types of distributed database architectures include client-server architecture, peer-to-peer architecture, and multi-tier architecture. B) Relational architecture, NoSQL architecture, Object-oriented architecture. C) Single-tier architecture, Two-tier architecture, Three-tier architecture. D) Centralized architecture, Decentralized architecture, Hybrid architecture. Show Answer Correct Answer: A) The different types of distributed database architectures include client-server architecture, peer-to-peer architecture, and multi-tier architecture. ← 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 3Class 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