Multiple choice technology programming languages

When is a Cartesian product formed?

  1. When a join condition is omitted.

  2. When a join condition is invalid.

  3. All rows in the first table are joined to all rows in the second table

  4. All of the above.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A Cartesian product (cross join) occurs when every row from the first table is joined with every row from the second table, creating n × m rows. This happens when the join condition is either omitted entirely, invalid (references non-existent columns), or when no WHERE clause restricts the join.

Keep practicing — related questions