Oracle
1Z0-061 · Question #56
1Z0-061 Question #56: Real Exam Question with Answer & Explanation
The correct answer is D. It produces an error because the order by clause should appear only at the end of a compound query-that. See the full explanation below for the reasoning.
Question
Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query?
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
Community Discussion
No community discussion yet for this question.