Which statement is true regarding the default behavior of the order by clause?
A.
In a character sort, the values are case-sensitive.
B.
NULL values are not considered at all by the sort operation.
C.
Only those columns that are specified in the select list can be used in the order by clause.
D.
Numeric values are displayed from the maximum to the minimum value if they have decimal positions.
Explanation:
Character Strings and Dates
Character strings and date values are enclosed with single quotation marks.
Character values are case-sensitive and date values are format-sensitive.
The default date display format is DD-MON-RR.
The column names referenced in the ORDER BY clause must correspond to either a column in the select list or to a column defined in a table specified in the FROM clause without any ambiguities.
http://www.orafaq.com/node/999