Question : Which of the following is NOT a basic Armstrong’s axiom?
Solution :
Correct Answer : Decomposition
Description -
Question : If X → YZ holds, which of the following must also be true?
Solution :
Correct Answer : X → Y and X → Z
Description -
Question : Which inference rule is derived using both augmentation and transitivity?
Solution :
Correct Answer : Reflexive
Description -
Question : Given:
X → Y and YZ → W
Which of the following can be inferred?
Solution :
Correct Answer : XZ → W
Description -
Question : Which of the following statements correctly applies the augmentation rule?
Solution :
Correct Answer : If X → Y, then XZ → YZ
Description -
Question : Consider a relation R(A, B, C) with functional dependencies:
A → B and B → C.
Which normal form is violated?
Solution :
Correct Answer : 3NF
Description -
Question : Which statement correctly differentiates BCNF from 3NF?
Solution :
Correct Answer : BCNF requires every determinant to be a candidate key
Description -
Question : Which of the following anomalies is NOT directly reduced by normalization?
Solution :
Correct Answer : Indexing anomaly
Description -
Question : A relation is in Third Normal Form (3NF) if it:
Solution :
Correct Answer : Is in 2NF and has no transitive dependency
Description -
Question : Which of the following best describes Second Normal Form (2NF)?
Solution :
Correct Answer : Removal of partial dependency on a composite key
Description -
Question : Which of the following violates functional dependency?
Solution :
Correct Answer : Same determinant → different dependents
Description -
Question : Given FD: (A, B) → C
If A → C also holds, then (A, B) → C is:
Solution :
Correct Answer : Partial dependency
Description -
Question : Consider relation R(A, B, C) with FDs:
A → B and B → A
Which statement is correct?
Solution :
Correct Answer : Both A and B are candidate keys
Description -
Question : Which of the following functional dependencies is completely non-trivial?
Solution :
Correct Answer : A → B (where A ∩ B = ∅)
Description -
Question : Given a relation R(A, B, C, D) with functional dependencies:
A → B, B → C, C → D
Which of the following is correct?
Solution :
Correct Answer : A → D is valid due to transitivity
Description -