Multiple choice technology databases

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 all rows from one table are combined with all rows from another. This happens when: (1) no join condition is specified, (2) the join condition is invalid or evaluates to false for all row combinations, or (3) explicitly requested. Option D correctly identifies all scenarios.

Keep practicing — related questions