Oracle Database SQL — Question 142

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

Answer options

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

Correct answer: A, D

Explanation

Statement A is correct because character sorting considers letter case, making it case-sensitive. Statement D is also correct as column aliases can indeed be utilized in the ORDER BY clause. Statements B, C, and E are incorrect; NULLs can be included in the sort, numeric values are not inherently sorted by decimal positions, and columns not in the SELECT list may also be used in the ORDER BY clause.