Home » MCQs » DBMS MCQs » DBMS Join Operations MCQs

What is TRUE about Left Outer Join?

11. What is TRUE about Left Outer Join?

1. It contains all tuples that have the same common attribute names in A and B.
2. Tuples in A do not match tuples in B in the left outer join.
3. It is denoted by ⟕.
4. All of the above

Answer: D) All of the above

Explanation:

Explanation: In case of Left Outer Join -

• It contains all tuples that have the same common attribute names in A and B.
• Tuples in A do not match tuples in B in the left outer join.
• It is denoted by ⟕.