→ A CROSS JOIN returns the Cartesian product of the two tables — meaning every row from the first table is paired with every row from the second table. If Table A has m rows and Table B has n rows, a CROSS JOIN will return m × n rows, making it the largest possible result set of all JOIN types.
Why the other options are incorrect:
A & B: RIGHT JOIN and LEFT JOIN return matched records plus unmatched rows from one side — but not all possible combinations.
D: INNER JOIN returns only matched rows between tables, typically producing fewer records than a CROSS JOIN.
Official References:
CompTIA DataX (DY0-001) Official Study Guide – Section 5.2:“CROSS JOINs generate the Cartesian product of two datasets and should be used carefully due to the exponential growth in the number of records.”
SQL for Data Scientists, Chapter 3:“CROSS JOINs can produce very large datasets, often unintentionally, due to their non-restrictive matching logic.”
—
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit