Which of the following category of join returns all records when there is a…
2018
Which of the following category of join returns all records when there is a match in either left or right table?
- A.
Inner join
- B.
Left outer join
- C.
Right outer join
- D.
Full outer join
Attempted by 222 students.
Show answer & explanation
Correct answer: D
A Full Outer Join returns all records when there is a match in either the left or right table. It combines both Left and Right Outer Joins, ensuring all rows from both tables are included regardless of matches.