retagged by
559 views
0 votes
0 votes
The number of tuples in the result of a left outer join operation will always be

(A) greater than the number of tuples in the result of the corresponding join operation.

(B)  at least equal to the number of tuples in the result of the corresponding join operation.

(C) less than the number of tuples in the result of the corresponding join operation.

(D) greater than the number of tuples in the result of the corresponding right outer join operation.
retagged by

1 Answer

0 votes
0 votes
The answer is option (B).

When we perform left outer join, we may get more tuples then in corresponding join operation because Left outer join includes all tuples of normal join operation  + unmatched tuples of Left relation(null values in right relation attributes). So, Left outer join is at least equal to the number of tuples in the result of the corresponding join operation.

Related questions