If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows,there will be 13 rows in the results.

Question

If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows,there will be 13 rows in the results.​

Quizplus · Accepted Answer

Cartesian join, also known as a cross join, combines every row of one table with every row of another table, resulting in the product of their rows. Therefore, a Cartesian join between a table with 5 rows and a table with 8 rows would result in 5 x 8 = 40 rows, not 13.

If a Cartesian Join Is Used to Link Table a Which