Question

The result of a CROSS JOIN between a table with 4 rows, and one with 5 rows, will give with _ rows.

a) 20 rows
b) 9 rows
c) 4 rows
d) 5 rows

Answer 1

The result of a CROSS JOIN between a table with 4 rows and a table with 5 rows will yield a new table with 20 rows.

Step-by-step explanation:

When you perform a CROSS JOIN between two tables in a database, you are producing a Cartesian product of those tables. This means every row from the first table is paired with every row from the second table. For instance, if you have a table with 4 rows and perform a CROSS JOIN with another table that has 5 rows, the result will be a new table with 4 x 5 = 20 rows. Therefore, the correct answer to the question is a) 20 rows.