Select the Statement That Is Correct About the Outer Join

Multiple Choice

Select the statement that is correct about the outer join operator:

A) The outer join operator generates the join result (the matching rows) .
B) The outer join operator generates the join result (the nonmatching rows) .
C) The outer join operator generates the join result (the matching rows) plus the nonmatching rows.
D) The outer join operator generates the join result (the nonmatching rows) but excludes the matching rows.