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, you need n-1 join conditions. Think of it as a chain: each new table requires one join to connect it to the existing set. For 10 tables: 10 - 1 = 9 joins. This applies to both explicit JOIN syntax and WHERE clause joins.

Keep practicing — related questions