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

asked in Databases by Loyal (3.4k points)   | 130 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

+1 vote
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 Boss (5.3k points)  


Top Users Sep 2017
  1. Habibkhan

    6826 Points

  2. Arjun

    2310 Points

  3. Warrior

    2302 Points

  4. nikunj

    1980 Points

  5. A_i_$_h

    1922 Points

  6. manu00x

    1750 Points

  7. rishu_darkshadow

    1744 Points

  8. Bikram

    1744 Points

  9. SiddharthMahapatra

    1718 Points

  10. makhdoom ghaya

    1690 Points


26,033 questions
33,618 answers
79,661 comments
31,066 users