The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
+2 votes

asked in Databases by Boss (5.1k points) | 178 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

+2 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 Boss (6.2k points)

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

29,156 questions
36,980 answers
34,822 users