Multiple choice technology packaged enterprise solutions

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

SQL is declarative, meaning the same query can be written in multiple syntactically different ways that produce the same result but generate vastly different execution plans. This makes SQL optimization complex and critical for performance. The optimizer must choose the best execution plan from semantically equivalent alternatives.

Keep practicing — related questions