Multiple choice technology databases

You use comments in a SQL statement to pass hints to the Oracle optimizer.

  1. False

  2. This is hard to determine

  3. True

  4. None of the choices
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle SQL, hints are passed to the optimizer using specially formatted comments starting with a plus sign, such as /*+ HINT */. Thus, the statement is true.

Keep practicing — related questions