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.

This CBSE Class 12 ICT practice quiz has 16 multiple-choice questions on Database Concepts, and 16 of them come with an explanation. Try the 5 sample questions below (tap an option to check yourself), then play the full quiz 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.

More questions in this quiz

Answers and explanations are in the full quiz.

1. What is a relational database?
2. Explain the concept of a primary key in a relational database.
3. What is normalization in database design?
4. Describe the difference between a SQL and NoSQL database.
5. Explain the concept of a foreign key and its role in relational databases.
6. What are database views and why are they useful?
7. Explain the concept of database indexing and its benefits in terms of query performance.
8. Compare and contrast different database models (hierarchical, network, relational, object-oriented, NoSQL). Discuss their strengths and weaknesses.
9. Discuss the implications of data integrity in a large-scale database system, including the various techniques used to maintain it (constraints, validation rules, triggers, etc.). Describe potential consequences of compromised data integrity.
10. Analyze the trade-offs between scalability, consistency, and availability in distributed database systems, considering the CAP theorem. Provide examples of different database systems that prioritize different aspects of the CAP theorem.
11. Design a database system for a social networking platform, considering aspects such as user profiles, posts, comments, friendships, and groups. Describe the tables, relationships, and data types you would use, and discuss potential scalability challenges.

Browse all Database Management Systems quizzes

More to play