Multiple choice technology databases

Which is a major problem with SQL?

  1. SQL cannot support object-orientation

  2. The same query can be written in many ways, each with vastly different execution plans.

  3. SQL syntax is too difficult for non-computer professionals to use

  4. SQL creates excessive locks within the database
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A core challenge in SQL is query performance variability - the same logical query can be expressed in syntactically different ways (different JOIN orders, subqueries vs. JOINs, EXISTS vs. IN, etc.), and each variation may generate a completely different execution plan with vastly different performance characteristics. This makes optimization crucial.

Keep practicing — related questions