GATE CSE
First time here? Checkout the FAQ!
x
+2 votes
98 views

asked in Databases by Loyal (3.3k points)   | 98 views
20 ?
20 tuples...

because r1 is left outer join with r2.... it means that all the tuples of r1 sould be present while joining the table r1 and r2

also due to tuples in r1....there will be some extra tuples which will have null values in r2(next 10 tuples of r2 will be null).

1 Answer

0 votes
Maximum is 20 and minimum is also 20.

If there is no match, So 20 Unmatched rows from R is returned.

If 10 rows are matched , 10 matched rows and 10 unmatched rows will be returned.
answered by Loyal (4.6k points)  


Top Users Jul 2017
  1. Bikram

    5258 Points

  2. manu00x

    3078 Points

  3. joshi_nitish

    1882 Points

  4. Debashish Deka

    1874 Points

  5. Arjun

    1814 Points

  6. pawan kumarln

    1336 Points

  7. Hemant Parihar

    1314 Points

  8. Shubhanshu

    1136 Points

  9. Arnab Bhadra

    1124 Points

  10. Tesla!

    1050 Points


24,122 questions
31,123 answers
70,821 comments
29,437 users