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

SQL is non-procedural and declarative, meaning the optimizer decides how to execute queries. A major challenge is that the same logical query can be written in multiple ways, yielding different execution plans and performance profiles.

Keep practicing — related questions