Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?

Question

Options

• ACross join
• BInner join
• CNatural join
• DOuter join

• A
  5% (2)
• B
  2% (1)
• C
  2% (1)
• D
  90% (38)

Explanation

An outer join returns all rows from one or both specified tables, including rows that have no matching row in the other table. Non-matching rows are filled with NULL values for the columns from the unmatched table. Outer joins come in three forms: LEFT OUTER (all rows from the left table), RIGHT OUTER (all rows from the right table), and FULL OUTER (all rows from both tables). By contrast, an INNER join returns only rows with matches in both tables, a CROSS join returns every combination of rows (no join condition), and a NATURAL join automatically joins on columns with the same name but still only returns matched rows.

No community discussion yet for this question.