Database Fundamentals — Question 54

You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?

Answer options

• A. 0
• B. 3
• C. 6
• D. 9

Correct answer: D

Explanation

The Cartesian product of two tables is calculated by multiplying the number of rows in each table. In this case, 3 rows from the first table multiplied by 3 rows from the second table results in 9 rows. Options A, B, and C are incorrect as they do not represent the correct multiplication of the rows in both tables.