Explanation:
: sorted by highest to lowest is DESCENDING order Incorrect answer :
1: result in ascending order
2: wrong syntax with SORT keyword
3: wrong syntax with SORT keyword
4: default value for ORDER by is in ascending order
5: wrong syntax with SORT keyword
Reference:
Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-22

---