Oracle
1Z0-071 · Question #27
Which statement is true regarding the default behavior of the ORDER BY clause?
The correct answer is A. In a character sort, the values are case-sensitive. 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.
Exadata Administration
Question
Which statement is true regarding the default behavior of the ORDER BY clause?
Options
- AIn a character sort, the values are case-sensitive
- BNULL values are not considered at all by the sort operation
- COnly those columns that are specified in the SELECT list can be used in the ORDER BY clause
- DNumeric values are displayed from the maximum to the minimum value if they have decimal
How the community answered
(31 responses)- A81% (25)
- B3% (1)
- C10% (3)
- D6% (2)
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.
Topics
#ORDER BY default behavior#character sort#NULL sort order#numeric sort
Community Discussion
No community discussion yet for this question.