Explanation:
: the two statement produce identical results as ORDER BY 2 will take the second column as sorting column. Incorrect answer :
2: there is no syntax error
3: result are sorted in ascending order by default
4: ORDER BY 2 will take the second column as sorting column.
Reference:
Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-22

---