Which statement is true regarding the default behavior of the ORDER BY clause?
Answer options
A
In a character sort, the values are case-sensitive.
B
Numeric values are sorted in descending order by default.
C
NULL values are always sorted first.
D
ORDER BY always requires DESC keyword.
Correct answer: In a character sort, the values are case-sensitive.
Explanation
Character sort in ORDER BY is case-sensitive by default in most RDBMS.