Skip to content
Related Articles

Related Articles

Save Article
Improve Article

GATE | GATE IT 2006 | Question 14

  • Last Updated : 28 Jun, 2021
Geek Week

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 :

(A) 2000
(B) 2500
(C) 4500
(D) 5000

Answer: (A)


r1⋈ r2  is a join operation done on the common attribute R. Further R is the primary key of R2

When we take a , the value of common attribute( R2 in this case) should match.The value of  R in r2 is matched with corresponding R in r1 . So it will have 2000 tuples. So correct option is (A).


Quiz of this Question

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :