Multiple choice technology web technology

Queries from universes containing SQL traps:

  1. Return fewer rows than expected.

  2. Return too many rows.

  3. Return incompatible objects error.

  4. Are correct only if an aggregate is applied
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL traps (fan traps, chasm traps) cause duplicate rows in query results by generating incorrect joins that multiply rows. This returns MORE rows than expected, not fewer. The issue is structural join problems, not incompatible objects or missing aggregates.

Keep practicing — related questions