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
Quick AnswerThe correct answer is In a character sort, the values are case-sensitive. because it directly addresses the core logic of Database Management.
Character sort in ORDER BY is case-sensitive by default in most RDBMS.