Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query?

Question

Exhibit

Options

• AIt executes successfully and displays rows in the descending order of PROMO_CATEGORY.
• BIt produces an error because positional notation cannot be used in the ORDER BY clause with
• CIt executes successfully but ignores the ORDER BY clause because it is not located at the end of
• DIt produces an error because the ORDER BY clause should appear only at the end of a

• A
  17% (5)
• B
  3% (1)
• C
  10% (3)
• D
  70% (21)

No community discussion yet for this question.