Multiple choice technology databases

The minimum number of join statements required to join 10 tables together are:

  1. 9

  2. 11

  3. 5

  4. 12

  5. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To join N tables together without creating a Cartesian product, a minimum of N-1 join conditions are required. For 10 tables, this formula yields 10 - 1 = 9 joins. Any fewer would result in incomplete relationships, while more are unnecessary.

Keep practicing — related questions