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 set operators.
• CIt executes successfully but ignores the order by clause because it is not located at the end of the
• DIt produces an error because the order by clause should appear only at the end of a compound query-that

• A
  4% (2)
• B
  12% (6)
• C
  6% (3)
• D
  78% (40)

No community discussion yet for this question.