This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 15 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 15 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What attributes are included in the table for translating a relationship set into a relational model? A) Only primary key attributes. B) Primary key attributes and descriptive attributes. C) Only descriptive attributes. D) No attributes. Show Answer Correct Answer: B) Primary key attributes and descriptive attributes. 2. Which of the following is an advantage of DBMS? A) Data redundancy. B) Data complexity. C) Data confusion. D) Data consistency. Show Answer Correct Answer: D) Data consistency. 3. A subtype is a generic entity that has a relationship with one or more entities at a lower level. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 4. What uniquely identifies each tuple in a table? A) Super Key. B) Candidate Key. C) Foreign Key. D) Primary Key. Show Answer Correct Answer: D) Primary Key. 5. IIn general, a file is basically a collection of all related ..... A) Rows & Columns. B) Fields. C) Database. D) Records. Show Answer Correct Answer: D) Records. 6. What is a transaction in a database? A) A transaction is a way to visualize data in a database. B) A transaction is a sequence of operations treated as a single unit of work in a database. C) A transaction is a method for deleting records. D) A transaction is a type of database backup. Show Answer Correct Answer: B) A transaction is a sequence of operations treated as a single unit of work in a database. 7. In the context of information systems, a database is: A) A random collection of files. B) A structured collection of related data. C) Only numerical data stored in a spreadsheet. D) The same as a file system. Show Answer Correct Answer: B) A structured collection of related data. 8. Which lock allows only one transaction to write? A) Shared lock. B) Binary lock. C) Exclusive lock. D) Update lock. Show Answer Correct Answer: C) Exclusive lock. 9. What is the purpose of data integrity constraints? A) To allow unlimited data entry without restrictions. B) To enhance the speed of data retrieval in a database. C) To provide a backup for lost data in the database. D) The purpose of data integrity constraints is to maintain the accuracy and consistency of data in a database. Show Answer Correct Answer: D) The purpose of data integrity constraints is to maintain the accuracy and consistency of data in a database. 10. In a relational database, what is a 'tuple' most commonly known as? A) A column. B) A table. C) A record or row. D) A primary key. Show Answer Correct Answer: C) A record or row. 11. What is one of the main functions of a DBMS? A) Data printing. B) Data storage management. C) Data visualization. D) Data entry. Show Answer Correct Answer: B) Data storage management. 12. Database System Architecture:The organization of database, DBMS, business logic, and ..... ? A) User interface. B) Network protocol. C) Data warehouse. D) Operating system. Show Answer Correct Answer: A) User interface. 13. What does the COUNT function do? A) Sums values. B) Counts rows. C) Finds minimum. D) Finds maximum. Show Answer Correct Answer: B) Counts rows. 14. What are the main components of the Relational Model? A) Tables, Rows, Columns, Primary Keys, Foreign Keys, Constraints. B) Schemas, Views, Triggers. C) Attributes, Entities, Relationships. D) Tables, Rows, Columns, Indexes. Show Answer Correct Answer: A) Tables, Rows, Columns, Primary Keys, Foreign Keys, Constraints. 15. Object-oriented databases are widely used in enterprise applications. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 16. What is the purpose of a query language in DBMS? A) To create backups of the database. B) The purpose of a query language in DBMS is to enable users to interact with and manipulate the data stored in the database. C) To store data in a structured format. D) To ensure data security and integrity. Show Answer Correct Answer: B) The purpose of a query language in DBMS is to enable users to interact with and manipulate the data stored in the database. 17. What is the main purpose of a 'foreign key'? A) To uniquely identify each record in its own table. B) To establish and enforce a link between two tables. C) To prevent data from being modified. D) To increase data redundancy for faster lookups. Show Answer Correct Answer: B) To establish and enforce a link between two tables. 18. What does the term 'schema' refer to in a database context? A) The process of data normalization. B) The method of data encryption. C) The structure that defines the organization of data. D) The physical storage of data. Show Answer Correct Answer: C) The structure that defines the organization of data. 19. A manager has requested a list of products from highest price to lowest. How would this information be retrieved? A) Sort Ascending. B) Sort Descending. C) Filter. D) Find. Show Answer Correct Answer: B) Sort Descending. 20. What feature of a database management system helps maintain data integrity? A) Manual data entry. B) Data encryption. C) Regular data backups. D) Open access to all users. Show Answer Correct Answer: C) Regular data backups. 21. What is the name for data about data? A) Unique data. B) Raw data. C) Metadata. D) Superdata. Show Answer Correct Answer: C) Metadata. 22. This SQL statement allows users to retrieve data from the a certain table. A) CREATE. B) SELECT. C) DROP. D) ALTER. Show Answer Correct Answer: B) SELECT. 23. ..... :Determining what actions a user can perform. A) Authorization. B) Authentication. C) Encryption. D) Validation. Show Answer Correct Answer: A) Authorization. 24. Which validation method ensures data follows a specific predefined pattern? A) Range check. B) Type check. C) Format check. D) Presence check. Show Answer Correct Answer: C) Format check. 25. What is the purpose of data validation in a database? A) To manage server-side logic. B) To ensure data is stored in multiple locations. C) To ensure data entered meets certain criteria. D) To create user interfaces. Show Answer Correct Answer: C) To ensure data entered meets certain criteria. ← 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