Chapter 3: Introduction to Database Management System — Online MCQ Test
COMPUTER APPLICATIONS · CLASS 12th · Tamil Nadu State Board
Practice Chapter 3: Introduction to Database Management System with a free chapter-wise online MCQ test.
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.
Chapter 3: Introduction to Database Management System — Important Questions & Answers
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.
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.
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 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.
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.
Normalization usually begins with 1NF, then 2NF, and then 3NF. Each stage removes a different type of dependency or redundancy.