Consider a schema R(A B C D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A B) and R2(C D) is

Explore topic-wise MCQs in Testing Subject.

This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.

1.	Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) 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» E.

Discussion

Previous Next

Explore topic-wise MCQs in Testing Subject.

Consider a schema R(A, B, C, D) and functional dependencies A -&gt; B and C -&gt; D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is