Oracle
1Z0-060 · Question #160
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.
Upgrading to Oracle Database 12c
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
(45 responses)- A89% (40)
- B2% (1)
- C2% (1)
- D7% (3)
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#sort behavior#NULL handling#character sort
Community Discussion
No community discussion yet for this question.