Question

What is the function of a left outer join?

(a) It preserves tuples only in the relation named before the operation

(b) It preserves tuples only in the relation named after the operation

(c) It preserved tuples in the relations named on both the sides of the operation

(d) It does not preserve any tuples on either side of the relation

I got this question in exam.

The question is from Join Expressions in portion Intermediate and Advanced Sql of RDBMS

Answer 1

Correct answer is (a) It preserves tuples only in the relation named before the operation

To explain I would say: The left outer join operation preserves the tuples named before the operation.