Multiple choice technology performance

How many minimum join conditions should exist if a SQL statement has 3 tables

  1. 1

  2. 2

  3. 3

  4. 4

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To join N tables in SQL without causing a Cartesian product, you need a minimum of N-1 join conditions. For 3 tables, N-1 equals 2 join conditions. Fewer conditions result in an unwanted cross join, while more conditions are unnecessary for a basic join structure.