Oracle Database SQL — Question 110

Which three statements are true about an ORDER BY clause? (Choose three.)

Answer options

• A. By default an ORDER BY clause sorts rows in descending order
• B. An ORDER BY clause will always precede a HAVING clause if both are used in the same top-level query.
• C. An ORDER BY clause always sorts NULL values last.
• D. By default an ORDER BY clause sorts rows in ascending order.
• E. An ORDER BY clause can perform a binary sort.
• F. An ORDER BY clause can perform a linguistic sort.

Correct answer: D, E, F

Explanation

The correct answer is D, E, and F because by default, the ORDER BY clause sorts rows in ascending order (D). Additionally, it can perform both binary sorts (E) and linguistic sorts (F), which are useful for different types of data. Options A, B, and C are incorrect because the default sort order is ascending, the positioning of the ORDER BY clause relative to HAVING can vary, and NULL values are sorted based on the database settings, not universally last.