Home » MCQs » DBMS MCQs » DBMS Join Operations MCQs

What is TRUE about Right Outer Join?

12. What is TRUE about Right Outer Join?

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

Answer: C) Both A and B

Explanation:

In case of Right Outer Join -

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