A join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.
A) natural
B) cross
C) full outer
D) left outer

Question

Quizplus · Accepted Answer

A full outer join returns all rows from both tables (T1 and T2), along with the matching rows. This means it includes both matched and unmatched values from both tables. A natural join returns only the matching rows, while a cross join returns all possible combinations of rows from both tables. A left outer join returns all rows from the left table (T1) and the matching rows from the right table (T2), but excludes any unmatched values from the right table.

A Join Returns Rows with Matching Values and Includes All