Question: Which of the following statements about SQL joins and their types is correct?

A) An INNER JOIN returns all rows from both tables involved in the join, regardless of whether there is a match between them.
B) A LEFT JOIN returns all rows from the right table and the matched rows from the left table; if there is no match, NULL values are returned for the left table.
C) A CROSS JOIN produces a Cartesian product of the two tables, resulting in all possible combinations of rows from both tables.
D) A FULL OUTER JOIN returns only the rows that have matches in both tables, excluding unmatched rows.