M

Mr. Dubey • 52.30K Points
Coach 

Q. 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
Correct : Option (D)

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. Predict the output? #include <iostream> using namespace std; class Test { int x; Test() { x = 5; } }; int main() { Test *t = new Test; cout <

Q. Magnetic disks are the most popular medium for

Q. The Subset relation on a set of sets is ________.

Q. What is the high speed memory between the main memory and the CPU called?

Q. COCOMO-II estimation model is based on

Q. At the end of the clock pulse the value of output Q is uncertain. The situation is referred to as?

Q. Which of the following is not a part of test plan?

Q. A sufficient condition that a triangle T be a right triangle is that a2 + b2 = c2. An equivalent statement is

Q. Data marts that incorporate data mining tools to extract sets of data are called ______.

Q. Which is the stages of law of variable proportions?