Database Concepts Quiz - CBSE Class 12 ICT

Free practice quiz: Database Concepts (CBSE Class 12 ICT). 16 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

Sample questions

1. What is a database?

   1. A collection of unrelated data
   2. A structured set of data organized for use
   3. A type of computer hardware
   4. A programming language
   Show answer

   Answer: B. A structured set of data organized for use

   A database is a structured collection of data organized for easy access, management, and updating.

2. What is data redundancy and why is it undesirable?

   1. Storing data in multiple locations for backup
   2. Storing the same data in multiple places
   3. Storing data in a compressed format
   4. Storing data in an encrypted format
   Show answer

   Answer: B. Storing the same data in multiple places

   Data redundancy refers to storing the same data in multiple places. It wastes storage space, increases update complexity, and can lead to inconsistencies.

3. What is an ACID property in database transactions?

   1. Atomicity, Consistency, Isolation, Durability
   2. Accuracy, Consistency, Integrity, Dependability
   3. Availability, Consistency, Integrity, Durability
   4. Atomicity, Capacity, Isolation, Durability
   Show answer

   Answer: A. Atomicity, Consistency, Isolation, Durability

   ACID properties (Atomicity, Consistency, Isolation, Durability) ensure reliable database transactions.

4. Discuss the different types of database relationships (one-to-one, one-to-many, many-to-many). Provide examples for each.

   1. Only one-to-many relationships are possible
   2. One-to-one: one employee, one ID; One-to-many: one department, many employees; Many-to-many: many students, many courses
   3. One-to-one: one customer, many orders; One-to-many: one product, one category; Many-to-many: one author, many books
   4. Only many-to-many relationships are practical in large databases
   Show answer

   Answer: B. One-to-one: one employee, one ID; One-to-many: one department, many employees; Many-to-many: many students, many courses

   The question tests understanding of different types of database relationships and ability to provide suitable examples. One-to-one represents a unique pairing, one-to-many indicates a single entity linked to multiple, and many-to-many signifies multiple entities connected to multiple others.

5. Design a relational database schema for a library management system, including tables for books, members, and loans. Define primary and foreign keys, and explain the relationships between the tables.

   1. This is not possible within the scope of a multiple-choice question.
   2. A suitable schema is complex and can't be displayed in options
   3. A simple schema would suffice for this question
   4. Provide details about books and member tables
   Show answer

   Answer: B. A suitable schema is complex and can't be displayed in options

   This question assesses the ability to design a relational database schema from scratch. The complexity makes it impossible to fit a complete solution in multiple-choice options. The correct answer acknowledges the complexity of the task.

Browse all Database Management Systems quizzes