____ operation preserves those tuples that would be lost in _____.
2018
____ operation preserves those tuples that would be lost in _____.
- A.
natural join, outer join
- B.
outer join, natural join
- C.
left outer join, right outer join
- D.
left outer join, natural join
Attempted by 1883 students.
Show answer & explanation
Correct answer: B
An outer join operation preserves those tuples that would be lost in a natural join. A full outer join returns all matching as well as non-matching rows from both the left and right tables.
A video solution is available for this question — log in and enroll to watch it.