Oracle
1Z0-061 · Question #43
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.
Restricting and Sorting Data
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 positions.
How the community answered
(37 responses)- A73% (27)
- B5% (2)
- C5% (2)
- D16% (6)
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 sort#NULL sort#character sort
Community Discussion
No community discussion yet for this question.