Related Articles
UGC-NET | UGC NET CS 2016 Aug – III | Question 9
• Last Updated : 16 Apr, 2018

Suppose database table T1(P, R) currently has tuples {(10, 5), (15, 8), (25, 6)} and table T2 (A, C) currently has {(10, 6), (25, 3), (10, 5)}. Consider the following three relational algebra queries RA1, RA2 and RA3:
RA1 : T1T1.P = T2.A T2 where ⨝is natural join symbol
RA2 : T1T1.P = T2.A T2 where ⟕ is left outer join symbol
RA3 : T1T1.P = T2.A and T1.R = T2.CT2
The number of tuples in the resulting table of RA1, RA2 and RA3 are given by:
(A) 2, 4, 2 respectively
(B) 2, 3, 2 respectively
(C) 3, 3, 1 respectively
(D) 3, 4, 1 respectively

Explanation: RA1 : T1T1.P = T2.A T2 where ⨝is natural join symbol. It will result 3 tuples:

P = ARC
1056
1055
2563

RA2 : T1T1.P = T2.A T2 where ⟕ is left outer join symbol. It will rewult in 4 tuples.

P = ARC
1056
1055
158Null
2563

RA3 : T1T1.P = T2.A and T1.R = T2.CT2. It will result in 1 tuple.

P = AR = C
105

So, option (D) is correct.

Quiz of this Question

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up