Suppose database table \(𝑇1(𝑃,𝑅)\) currently has tuples…

Suppose database table 𝑇1(𝑃,𝑅)𝑇1(𝑃,𝑅) currently has tuples (10,5),(15,8),(25,6)(10,5),(15,8),(25,6) and table 𝑇2(𝐴,𝐶)𝑇2(𝐴,𝐶) currently has (10,6),(25,3),(10,5)(10,6),(25,3),(10,5). Consider the following three relational algebra queries 𝑅𝐴1,𝑅𝐴2𝑅𝐴1,𝑅𝐴2 and 𝑅𝐴3𝑅𝐴3:

𝑅𝐴1𝑅𝐴1 : T1⋈T1.P=T2.A T2T1 \Join _{T1.P = T2.A}\ T2 where ⋈\Join is the join symbol (applied here using the stated condition)

𝑅𝐴2𝑅𝐴2 : T1=⋈T1.P=T2.A T2T1 =\Join _{T1.P = T2.A}\ T2 where =⋈=\Join is left outer join symbol

𝑅𝐴3𝑅𝐴3 : T1⋈T1.P=T2.AT1 \Join_{T1.P = T2.A} and T1.R=T2.CT2_{T1.R = T2.C} T2

The number of tuples in the resulting table of RA1,RA2RA1, RA2 and RA3RA3 are given by :

  1. A.

    2,4,2 respectively

  2. B.

    2,3,2 respectively

  3. C.

    3,3,1 respectively

  4. D.

    3,4,1 respectively

Attempted by 122 students.

Sign up free to check your answer

Sign up free

Explore the full course: Uppsc Polytechnic Lecturer 2025 Cs

Loading lesson…