This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 23 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 23 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is an example of an application of DBMS? A) Online shopping B) Cooking Dishes C) Painting Art D) Gardening Tips A) E) Online banking. B) A) Online shopping. C) G) Video streaming. D) F) Social media. Show Answer Correct Answer: B) A) Online shopping. 2. What is defined by the WWW Consortium (W3C) and was originally intended as a document markup language? A) XML. B) JSON. C) HTML. D) None of the above. Show Answer Correct Answer: A) XML. 3. In any programming paradigms, the primary function that every programing must have is: A) Main(). B) Void(). C) User defined(). D) Define(). Show Answer Correct Answer: A) Main(). 4. What is the function of a database management system? A) To create and design websites. B) To perform complex mathematical calculations. C) To manage user interface elements. D) The function of a database management system is to facilitate the storage, retrieval, and management of data in databases. Show Answer Correct Answer: D) The function of a database management system is to facilitate the storage, retrieval, and management of data in databases. 5. Which of the following is a feature of a NoSQL database? A) ACID transactions. B) Support for unstructured data. C) Table-based structure. D) Fixed schema. Show Answer Correct Answer: B) Support for unstructured data. 6. What is a transaction in the context of a DBMS? A) A user access level. B) A method of data storage. C) A collection of operations treated as a single unit. D) A type of data model. Show Answer Correct Answer: C) A collection of operations treated as a single unit. 7. Identify the query that deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation? A) DELETE FROM instructor WHERE dept name IN 'Watson';. B) DELETE FROM department WHERE building='Watson';. C) DELETE FROM instructor WHERE dept name IN (SELECT dept name FROM department WHERE building = 'Watson');. D) None. Show Answer Correct Answer: C) DELETE FROM instructor WHERE dept name IN (SELECT dept name FROM department WHERE building = 'Watson');. 8. Which of the following correctly represents the basic syntax structure of the INSERT INTO command? A) INSERT INTO [table name] VALUES ([value1], [value2] ). B) UPDATE [table name] SET [column1]=[value1], [column2]=[value2] . C) DELETE FROM [table name] WHERE [condition]. D) INSERT INTO [table name] ([column1], [column2] ) VALUES ([value1], [value2] ). Show Answer Correct Answer: D) INSERT INTO [table name] ([column1], [column2] ) VALUES ([value1], [value2] ). 9. What is the purpose of SQL in a DBMS? A) To visualize data through graphical interfaces. B) The purpose of SQL in a DBMS is to manage and manipulate relational databases. C) To store data in a non-relational format. D) To create and design new databases. Show Answer Correct Answer: B) The purpose of SQL in a DBMS is to manage and manipulate relational databases. 10. Text, Integer, Currency, Boolean and Date/Time are all examples of ..... A) Data Types. B) Filters. C) Sorts. D) Validations. Show Answer Correct Answer: A) Data Types. 11. Atomicity:All operations in a transaction occur or ..... A) None occur. B) Some occur. C) All fail. D) Partially occur. Show Answer Correct Answer: A) None occur. 12. Define an entity in the context of the ER Model. A) An entity is a distinct object or thing in the real world that can be identified and has attributes. B) An entity is a type of relationship between two objects. C) An entity is a collection of attributes without any identifiable object. D) An entity is a process that describes how data is manipulated. Show Answer Correct Answer: A) An entity is a distinct object or thing in the real world that can be identified and has attributes. 13. A database that stores information about farmers, crops, soil tests, and yields can be categorized as: A) Statistical Database. B) Agricultural Information System (Agri-IS). C) Multimedia Database. D) Temporal Database. Show Answer Correct Answer: B) Agricultural Information System (Agri-IS). 14. How many tables are needed for a strong entity set with multi-valued attributes? A) Three. B) Four. C) Two. D) One. Show Answer Correct Answer: C) Two. 15. ACID properties are essential for ensuring data reliability in financial transactions. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 16. What is a transaction in the context of database management? A) A transaction is a method for deleting all records in a database. B) A transaction is a backup of the database. C) A transaction is a type of database that stores data permanently. D) A transaction is a sequence of operations treated as a single unit of work in a database. Show Answer Correct Answer: D) A transaction is a sequence of operations treated as a single unit of work in a database. 17. Occurs when multiple users seeking access to the same set of records lockout each other. A) Data manipulation. B) Deadlock. C) Database lockout. D) Data redundancy. Show Answer Correct Answer: B) Deadlock. 18. ..... :Business logic layer. A) Application Tier. B) Presentation Tier. C) Data Tier. D) Network Tier. Show Answer Correct Answer: A) Application Tier. 19. What is the purpose of keys in a relational database? A) To encrypt sensitive data in the database. B) The purpose of keys in a relational database is to uniquely identify records and establish relationships between tables. C) To store large binary files efficiently. D) To improve the speed of data retrieval operations. Show Answer Correct Answer: B) The purpose of keys in a relational database is to uniquely identify records and establish relationships between tables. 20. What is an Entity-Relationship (ER) model used for? A) To visualize data relationships. B) To store data. C) To manage user access. D) To encrypt data. Show Answer Correct Answer: A) To visualize data relationships. 21. .... is a database tool used by developers and DBA's mainly for visualization. A) HeidiSQL. B) PHPMYADMIN. C) Python. D) MySQL Workbench. Show Answer Correct Answer: D) MySQL Workbench. 22. Define the term 'data integrity' in the context of databases. A) Data integrity refers to the speed of data retrieval in a database. B) Data integrity is the process of backing up data regularly. C) Data integrity is the accuracy, consistency, and reliability of data in a database. D) Data integrity means the amount of data stored in a database. Show Answer Correct Answer: C) Data integrity is the accuracy, consistency, and reliability of data in a database. 23. Shared Lock (S Lock):Allows multiple transactions to ..... a data item. A) Read. B) Write. C) Delete. D) Update. Show Answer Correct Answer: A) Read. 24. A search key containing more than one attribute is referred to as a ..... search key. A) Simple. B) Composite. C) Compound. D) Secondary. Show Answer Correct Answer: B) Composite. 25. Which language is commonly used to interact with a relational DBMS? A) HTML. B) SQL. C) CSS. D) XML. Show Answer Correct Answer: B) SQL. ← 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