Chapter Exam

Chapter 3: Introduction to Database Management System — Online MCQ Test

Q: What does DBMS stand for?

Answer: A. Database Management System — DBMS stands for Database Management System. It is software used to create, store, manage, and retrieve data efficiently.

Q: Which key uniquely identifies each record in a table?

Answer: B. Primary key — A primary key uniquely identifies each row in a table. It cannot have duplicate or null values.

Q: Which of the following best describes a foreign key?

Answer: B. A key used to connect two tables — A foreign key is a field in one table that refers to the primary key of another table. It creates a relationship between the two tables.

Q: A student database has StudentID, StudentName, and DepartmentName. If DepartmentName repeats for many students, which is the best reason to separate Department into another table?

Answer: C. To avoid redundancy and update anomalies — Separating Department into another table reduces repeated data and avoids anomalies during updates. This is a common normalization step.

Q: Which of the following is the correct order of normal forms commonly taught in basic database design?

Answer: C. 1NF → 2NF → 3NF — Normalization usually begins with 1NF, then 2NF, and then 3NF. Each stage removes a different type of dependency or redundancy.

COMPUTER APPLICATIONS · CLASS 12th · Tamil Nadu State Board

Practice Chapter 3: Introduction to Database Management System with a free chapter-wise online MCQ test for Tamil Nadu State Board CLASS 12th COMPUTER APPLICATIONS. This chapter covers: This chapter details relational database concepts data models and SQL query fundamentals. Students explore ER diagrams primary and foreign keys normalization techniques and relatio.... 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 3: Introduction to Database Management System — Important Questions & Answers (FAQ)

Frequently asked questions from Tamil Nadu State Board CLASS 12th COMPUTER APPLICATIONS — Chapter 3: Introduction to Database Management System, with answers and explanations. These are sample questions; the exam has its own separate question set.

What does DBMS stand for?

A. Database Management System ✓
B. Data Backup Management System
C. Digital Basic Management Software
D. Database Model Structure

Answer: A. Database Management System
DBMS stands for Database Management System. It is software used to create, store, manage, and retrieve data efficiently.

Which key uniquely identifies each record in a table?

A. Foreign key
B. Primary key ✓
C. Candidate key
D. Composite key

Answer: B. Primary key
A primary key uniquely identifies each row in a table. It cannot have duplicate or null values.

Which of the following best describes a foreign key?

A. A key that uniquely identifies a table
B. A key used to connect two tables ✓
C. A key that stores only numeric values
D. A key that cannot appear in any relation

Answer: B. A key used to connect two tables
A foreign key is a field in one table that refers to the primary key of another table. It creates a relationship between the two tables.

A student database has StudentID, StudentName, and DepartmentName. If DepartmentName repeats for many students, which is the best reason to separate Department into another table?

A. To increase duplicate values
B. To create more null values
C. To avoid redundancy and update anomalies ✓
D. To eliminate StudentID

Answer: C. To avoid redundancy and update anomalies
Separating Department into another table reduces repeated data and avoids anomalies during updates. This is a common normalization step.

Which of the following is the correct order of normal forms commonly taught in basic database design?

A. 3NF → 2NF → 1NF
B. 2NF → 1NF → 3NF
C. 1NF → 2NF → 3NF ✓
D. BCNF → 3NF → 2NF

Answer: C. 1NF → 2NF → 3NF
Normalization usually begins with 1NF, then 2NF, and then 3NF. Each stage removes a different type of dependency or redundancy.

← Previous Chapter

Chapter 2: An Introduction to Adobe PageMaker

Next Chapter →

Chapter 4: PHP: Hypertext Preprocessor