Question

If table A has 10 rows and table B has 5 rows, how many rows will be returned if you perform a cartesian join on those two tables?

a.5
b.15
c.10
d.50

Answer 1

A cartesian join between table A with 10 rows and table B with 5 rows will return a total of 50 rows as it is the product of the number of rows from both tables.

Step-by-step explanation:

If you perform a cartesian join (also known as a cross join) between table A, which has 10 rows, and table B, which has 5 rows, the number of rows returned will be the product of the number of rows in table A and the number of rows in table B. This results in a cartesian product of the two sets of rows. Therefore, you would expect 10 rows from table A to be joined with each of the 5 rows in table B, for a total of 50 rows. So the correct answer is:

• a. 5
• b. 15
• c. 10
• d. 50