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.
I think “C” is also correct.
I agree
C is not correct as you can use other colums as well in order by clause which are not part of select clause.
You’re right.