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.
Yes, A. If sayed and Sayed are two values ORDER BY put Sayed first then sayed. ORDER BY also put null values at the bottom. ORDER BY DESC does the opposite.