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?
Answer: D. Full outer join — 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…
- A.
Inner join
- B.
Left outer join
- C.
Right outer join
- D.
Full outer join
Attempted by 927 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.
Loading lesson…