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 major problem with SQL is that logically equivalent queries can be written in multiple ways, and each variation may produce vastly different execution plans. This makes query optimization challenging - a simple syntax change can dramatically affect performance.

Keep practicing — related questions