Multiple choice technology databases

When will a Cartesian product be returned

  1. when two tables in a join query have only a single join condition

  2. when two tables in a join query have too many join conditions

  3. This is hard to determine.

  4. when two tables in a join query have no join condition
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A Cartesian product (cross join) occurs when two tables are joined without any join condition or WHERE clause linking them. Every row from the first table is paired with every row from the second table.

Keep practicing — related questions