Gate CS-2001 Question Paper With Solutions

Q. 24 Consider a schema R(A,B,C,D) and functional dependencies A->B and C->D.

Then the decomposition of R into R1(AB) and R2(CD) is

(A) dependency preserving and lossless join

(B) lossless join but not dependency preserving

(C) dependency preserving but not lossless join

(D) not dependency preserving and not lossless join

Answer: (C)

Explanation:

Gate CS-2001 Question Paper With Solutions

Learn More:   Gate EE-2019 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here