A(n)____ join returns all rows from both tables with null values replacing missing values.
A) inner
B) left outer
C) right outer
D) full outer

Question

Quizplus · Accepted Answer

A full outer join combines the results of both left and right outer joins. It returns all matching rows and non-matching rows from both tables, with null values replacing missing values in some cells. Therefore, option D (full outer join) is the correct choice here.

A(n)____ Join Returns All Rows from Both Tables with Null