This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 28 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 28 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A company decides to migrate its data from a file-processing system to a DBMS. What is the most significant challenge they will face? A) Finding enough storage space for the data. B) Managing the small increase in data redundancy. C) Converting existing applications to interact with the new DBMS. D) The lack of security features in a DBMS. Show Answer Correct Answer: C) Converting existing applications to interact with the new DBMS. 2. What are some common database security measures? A) User training programs. B) Data backups. C) Performance monitoring. D) Access controls, encryption, regular updates, security audits, firewalls. Show Answer Correct Answer: D) Access controls, encryption, regular updates, security audits, firewalls. 3. Database can be define as ..... A) An integrated collection of related data. B) Unprocessed items. C) Rows and columns that make up a table. D) Related data that has been categorized in to specific fields. Show Answer Correct Answer: A) An integrated collection of related data. 4. A centralized database architecture means: A) Data is distributed among multiple servers. B) Data resides in a single location. C) Data is stored on the cloud. D) Data is replicated across servers. Show Answer Correct Answer: B) Data resides in a single location. 5. Identify the spatial index structure that is effective for indexing data in multi-dimensional spaces A) R-tree. B) Quadtree. C) Grid file. D) Kd-tree. Show Answer Correct Answer: A) R-tree. 6. Which technique prevents invalid data being saved in Access table? A) Index. B) Filter. C) Validation rule. D) Input mark. Show Answer Correct Answer: C) Validation rule. 7. "Delete from Student;"The above command performs which of the following action? A) Removes table from database. B) Removes tuples from the table. C) Removes fields/columns from the table. D) Removes constraints from the table. Show Answer Correct Answer: B) Removes tuples from the table. 8. How does the three-tier schema architecture promote data independence? A) It requires all levels to be changed simultaneously. B) The three-tier schema architecture promotes data independence by allowing changes at one level without affecting the others. C) It enforces a single schema for all data access. D) It eliminates the need for a database entirely. Show Answer Correct Answer: B) The three-tier schema architecture promotes data independence by allowing changes at one level without affecting the others. 9. What is the actual content of the database at a particular point in time called? A) Instance. B) Schema. C) Data Model. D) None of the above. Show Answer Correct Answer: A) Instance. 10. Which factor determines whether a database is classified as single-user or multiuser? A) The type of operating system used. B) The number of users. C) The amount of data stored. D) The speed of the computer. Show Answer Correct Answer: B) The number of users. 11. A scout company have a database with records of all the scouts. They want to create a list of all scouts who are under 15 and their achievements. What would they use? A) Report. B) Form. C) Query. D) Sort. Show Answer Correct Answer: C) Query. 12. It is the use sophisticated statistical analysis, including artificial intelligence techniques such as neural networks, to "discover" unhypothesized relationships in the data. For example, credit card companies use this to identify usage patterns indicative of fraud. A) Data integration. B) Data Sharing. C) Data Mining. D) Database system. Show Answer Correct Answer: C) Data Mining. 13. Which property ensures data consistency in a database? A) Availability. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: B) Consistency. 14. Which of the following best describes a database schema? A) The overall design of the database. B) The current data in the database. C) The user interface of the database. D) The security settings of the database. Show Answer Correct Answer: A) The overall design of the database. 15. What is a transaction in a DBMS? A) A transaction is a method for data retrieval in a DBMS. B) A transaction is a single operation in a DBMS. C) A transaction is a temporary data storage in a DBMS. D) A transaction is a sequence of operations treated as a single unit of work in a DBMS. Show Answer Correct Answer: D) A transaction is a sequence of operations treated as a single unit of work in a DBMS. 16. What data type would be used to store the following item code:0024 A) Text. B) Numeric. C) Calculated. D) Boolean. Show Answer Correct Answer: A) Text. 17. Which DBMS architecture uses a middle layer between client and database? A) 1-Tier. B) 2-Tier. C) 3-Tier. D) 4-Tier. Show Answer Correct Answer: C) 3-Tier. 18. In an Entity-Relationship Diagram (ERD), an arrow line represents what? A) An entity. B) A relationship. C) An attribute. D) A primary key. Show Answer Correct Answer: B) A relationship. 19. Which database language is commonly used for querying relational databases? A) HTML. B) CSS. C) SQL. D) Java. Show Answer Correct Answer: C) SQL. 20. What additional elements are needed, besides data, to produce information according to the formula provided? A) Context, structure, and analysis. B) Only context. C) Only structure. D) Only analysis. Show Answer Correct Answer: A) Context, structure, and analysis. 21. The result of a SELECT statement can contain duplicate rows . A) False. B) True. C) None of the above. D) None of the above. Show Answer Correct Answer: B) True. 22. Which of the following is a key component of database architecture? A) Keyboard. B) Monitor. C) Storage device. D) Database server. Show Answer Correct Answer: D) Database server. 23. ..... :Unfair outcomes caused by data or algorithms. A) Bias in Data. B) Data Encryption. C) Algorithm Efficiency. D) Data Visualization. Show Answer Correct Answer: A) Bias in Data. 24. Define a trigger in the context of a database. A) A trigger is a type of database index that improves query performance. B) A trigger is a user-defined function that returns a value. C) A trigger is a command that manually updates a database record. D) A trigger is a database object that automatically executes a specified action in response to certain events on a table or view. Show Answer Correct Answer: D) A trigger is a database object that automatically executes a specified action in response to certain events on a table or view. 25. True or False:Can a database management system completely eliminate the need for manual data entry in healthcare? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. ← 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 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books