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

asked in Databases by Loyal (3.2k points)   | 87 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 (3.1k points)  

Related questions

+2 votes
1 answer
1
0 votes
1 answer
2
+1 vote
1 answer
3


Top Users Jun 2017
  1. Bikram

    2512 Points

  2. Hemant Parihar

    1480 Points

  3. junaid ahmad

    1432 Points

  4. Arnab Bhadra

    1334 Points

  5. Niraj Singh 2

    1311 Points

  6. rahul sharma 5

    1060 Points

  7. Rupendra Choudhary

    1042 Points

  8. Debashish Deka

    888 Points

  9. Arjun

    856 Points

  10. srestha

    836 Points

Monthly Topper: Rs. 500 gift card
Top Users 2017 Jun 19 - 25
  1. Niraj Singh 2

    1306 Points

  2. Bikram

    768 Points

  3. junaid ahmad

    502 Points

  4. akankshadewangan24

    252 Points

  5. joshi_nitish

    250 Points


23,325 questions
29,999 answers
67,196 comments
28,337 users