Oracle Database Administration I — Question 131

Which two statements are true about the ORDER BY clause? (Choose two.)

Answer options

• A. Only columns that are specified in the SELECT list can be used in the ORDER BY clause.
• B. Numeric values are displayed in descending order if they have decimal positions.
• C. NULLS are not included in the sort operation.
• D. Column aliases can be used in the ORDER BY clause.
• E. In a character sort, the values are case-sensitive.

Correct answer: D, E

Explanation

The correct answers are D and E. Column aliases can indeed be used in the ORDER BY clause, allowing for more readable queries, while character sorting is case-sensitive, affecting the order of the results. Options A and C are incorrect because columns not in the SELECT list can still be referenced in ORDER BY, and NULL values are typically included in the sort, depending on the database system.