Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q311: A relation is in second normal form if and only if it is in _______ and all nonkey attributes are fully functionally dependent on the key.
- A: First Normal Form
- B: Third Normal Form
- C: Fourth Normal Form
- D: Fifth Normal Form
View Answer
A
Q312: What anomaly occurs when inserting a new course without any students registered in it?
- A: Insertion Anomaly
- B: Deletion Anomaly
- C: Update Anomaly
- D: Redundancy
View Answer
A
Q313: Which of the following is a requirement for a relation to be in second normal form (2NF)?
- A: All non-key attributes must be functionally dependent on a composite key
- B: All attributes must be functionally dependent on a single attribute key
- C: No non-key attributes should be present in the relation
- D: All attributes should be fully dependent on the primary key
View Answer
B
Q314: In the provided example, the course ID C3456 is repeated for which attribute?
- A: Faculty ID and Room
- B: Student ID and Name
- C: Grade and Room
- D: Student ID and Grade
View Answer
A
Q315: The relation STD(stId, stName, stAdr, prName, prCrdts) has a transitive dependency if:
- A: prCrdts depends on stAdr
- B: stName depends on prCrdts
- C: prCrdts depends on prName
- D: stAdr depends on stName
View Answer
C
Q316: In which normal form are the relations STD (stId, stName, stAdr, prName) and PROGRAM (prName, prCrdts) considered to be?
- A: First Normal Form (1NF)
- B: Second Normal Form (2NF)
- C: Third Normal Form (3NF)
- D: Fourth Normal Form (4NF)
View Answer
C
Q317: Which anomaly occurs when deleting a record of a student, and the information about the course is also deleted?
- A: Deletion Anomaly
- B: Insertion Anomaly
- C: Update Anomaly
- D: Redundancy
View Answer
A
Q318: A relation is in Boyce-Codd Normal Form (BCNF) if:
- A: Every determinant is a candidate key
- B: Every non-key attribute is functionally dependent on the primary key
- C: Every attribute is fully functionally dependent on the key
- D: All tables are in 3NF
View Answer
A
Q319: Which of the following is a higher normal form after BCNF?
- A: Fourth Normal Form (4NF)
- B: Third Normal Form (3NF)
- C: Fifth Normal Form (5NF)
- D: Domain-Key Normal Form (DKNF)
View Answer
A
Q320: In the example given, which of the following decompositions removes the anomalies?
- A: STD (stId, stName), COURSE (crId, fId, room), CLASS (crId, stId, grade)
- B: STD (stId, stName, stAdr), PROGRAM (prName, prCrdts)
- C: CLASS (crId, stId, fId, room), STD (stId, stName, grade)
- D: STD (stId, stName), COURSE (crId, room), CLASS (crId, stId, grade)
View Answer
A