How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?
A) 8
B) 18
C) 26
D) 144

Question

Quizplus · Accepted Answer

A cross join or Cartesian product of two tables returns the number of rows equal to the product of the number of rows in each table. So, the cross join of tables A (8 rows) and B (18 rows) would return 8 x 18 = 144 rows. Therefore, option D is the correct answer.

How Many Rows Would Be Returned from a Cross Join