Multiple choice technology mainframe

Number of Tables that can be joined in a single query are

  1. 8

  2. 15

  3. 16

  4. 256
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DB2 allows joining up to 15 tables in a single SELECT query. This limit balances query complexity with performance considerations in the DB2 optimizer. 8 tables is possible but not the maximum. 16 exceeds the limit, and 256 is far beyond practical join limits. Joining many tables requires careful indexing and query optimization.

Keep practicing — related questions