Theory-of-Computation
October 3, 2023Nielit Scientist-C 2016 march
October 3, 2023GATE 2006-IT
|
Question 14
|
Consider the relations r1(P, Q, R) and r2(R, S, T) with primary keys P and R respectively. The relation r1 contains 2000 tuples and r2 contains 2500 tuples. The maximum size of the join r1⋈ r2 is :
|
2000
|
|
|
2500
|
|
|
4500
|
|
|
5000
|
Question 14 Explanation:
r1⋈ r2 is a join operation done on the common attribute R. So this can have 2000 tuples.
Correct Answer: A
Question 14 Explanation:
r1⋈ r2 is a join operation done on the common attribute R. So this can have 2000 tuples.