Oracle
1Z0-071 · Question #80
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
(45 responses)- A71% (32)
- B2% (1)
- C18% (8)
- D9% (4)
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 sort order#case sensitivity
Community Discussion
No community discussion yet for this question.