If relation R has X tuples and relation S has Y tuples, then the result of…
2022
If relation R has X tuples and relation S has Y tuples, then the result of join on relation R and S will have up to _______ tuples.
- A.
X/Y
- B.
X*Y
- C.
X+Y
- D.
X-Y
Attempted by 469 students.
Show answer & explanation
Correct answer: B
For two relations R(X tuples) and S(Y tuples) : The maximum number of tuples in a join result is obtained in a Cartesian product , which yields X × Y tuples.
Natural join or equi-join will produce ≤ X × Y , but the maximum possible is X × Y .