Oracle
1Z0-061 · Question #86
1Z0-061 Question #86: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #86. The question stem and answer options stay visible for context.
Question
Evaluate these two SQL statements: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?
Options
- AThe two statements produce identical results.
- BThe second statement returns a syntax error.
- CThere is no need to specify DESC because the results are sorted in descending order by default.
- DThe two statements can be made to produce identical results by adding a column alias for the
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.