Oracle
1Z0-071 · Question #298
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. The ORDER BY clause performs case sensitive sorting with character values.
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.
- BNULLs are not included in the sort operation.
- COnly columns that are specified in the SELECT list can be used in the ORDER BY clause.
- DNumeric values are displayed in descending order if they have decimal positions.
- EColumn aliases can be used in the ORDER BY clause.
How the community answered
(31 responses)- A81% (25)
- B10% (3)
- D3% (1)
- E6% (2)
Explanation
The ORDER BY clause performs case sensitive sorting with character values.
Topics
#ORDER BY#sorting#NULL handling#column aliases
Community Discussion
No community discussion yet for this question.