UGC NET MODEL SOLVED PAPER FOR
DECEMBER 2014
1. Every time attribute P appears, it is matched with the
same value of attribute Q, but not the same
value of attribute R.
Therefore, it is true that:
(A) P ®Q
(B) P ®R
(C) P ® (Q,R).
(D) (Q,R)® P
Ans.: A.
Reason: Value of P matches only with
value of Q
2. A 3NF removes
A. Repeating groups
B. Partial functional dependency
C. Transisitive functional dependency
D. Other higher functional dependency
Ans.: C.
Reason: Transitive functional
dependency exists when a non key attribute value is functionally dependent
on another non key attribute
