Explanation:
These two statements produce identical results, because it is possible even to use numbers to indicate the column position where Oracle should order the output from a statement.
Incorrect Answers:
2: Second statement is correct and it will not return a syntax error.
3: The results are sorted in ascending order by default.
4: There is no corrections need to be made for the statements. They will return identical results.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 56-61
Chapter 2: Limiting, Sorting, and Manipulating Return Data

---