Multiple choice general knowledge science & technology

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 the same query can be written in multiple syntactically correct ways, each producing vastly different execution plans and performance characteristics. This makes optimization challenging and query performance unpredictable. SQL does support some object-oriented features, the syntax is designed for professionals, and locking behavior is configurable.

Keep practicing — related questions