Chapter Exam

Chapter 11: Database Concepts — Online MCQ Test

Q: What is the main purpose of a Database Management System (DBMS)?

Answer: B. To store, manage, and retrieve data efficiently — A DBMS is software used to organize and manage data so that it can be accessed and updated efficiently.

Q: Which of the following is an example of a relational database object used to store data in rows and columns?

Answer: A. Table — In the relational model, data is stored in tables made up of rows and columns.

Q: In a relational database, a foreign key is used to:

Answer: B. Link one table to another table — A foreign key establishes a relationship between two tables by referring to the primary key of another table.

Q: A school stores student marks in separate files for each subject. The same student details are repeated in every file. Which DBMS feature can best solve this problem?

Answer: B. Data redundancy reduction — A DBMS reduces repeated storage of the same data by organizing it properly in related tables.

Q: Which option correctly matches the relationship between two tables where one department can have many students, but each student belongs to only one department?

Answer: C. One-to-many — One department can relate to many students, so the relationship is one-to-many.

COMPUTER SCIENCE · CLASS 12th · Tamil Nadu State Board

Practice Chapter 11: Database Concepts with a free chapter-wise online MCQ test for Tamil Nadu State Board CLASS 12th COMPUTER SCIENCE. This chapter covers: This foundational chapter explores database management systems and relational database concepts. It covers data models keys table relations components of database architecture and.... AI-generated questions from basic to board-exam level, with instant results and explanations.

Questions

20m

Time Limit

Attempts Left

10 random questions from this chapter (mixed difficulty)
Questions you've seen before won't repeat until the pool resets
You have 20 minutes — exam auto-submits when time is up
Maximum 3 attempts per chapter
Results and explanations shown immediately after submission

New here? Register free — includes 3 free chapter exams.

Chapter 11: Database Concepts — Important Questions & Answers (FAQ)

Frequently asked questions from Tamil Nadu State Board CLASS 12th COMPUTER SCIENCE — Chapter 11: Database Concepts, with answers and explanations. These are sample questions; the exam has its own separate question set.

What is the main purpose of a Database Management System (DBMS)?

A. To design computer hardware
B. To store, manage, and retrieve data efficiently ✓
C. To create only presentation slides
D. To format text documents

Answer: B. To store, manage, and retrieve data efficiently
A DBMS is software used to organize and manage data so that it can be accessed and updated efficiently.

Which of the following is an example of a relational database object used to store data in rows and columns?

A. Table ✓
B. Folder
C. Window
D. Icon

Answer: A. Table
In the relational model, data is stored in tables made up of rows and columns.

In a relational database, a foreign key is used to:

A. Uniquely identify records in the same table
B. Link one table to another table ✓
C. Store only text data
D. Delete duplicate rows automatically

Answer: B. Link one table to another table
A foreign key establishes a relationship between two tables by referring to the primary key of another table.

A school stores student marks in separate files for each subject. The same student details are repeated in every file. Which DBMS feature can best solve this problem?

A. Data encryption
B. Data redundancy reduction ✓
C. Data output formatting
D. Data compression only

Answer: B. Data redundancy reduction
A DBMS reduces repeated storage of the same data by organizing it properly in related tables.

Which option correctly matches the relationship between two tables where one department can have many students, but each student belongs to only one department?