|
Explanation: The ORDER BY clause does sort data in ascending order by default. And the ORDER BY clause comes last in the SELECT statement: after FROM or WHERE or GROUP BY clause. Incorrect Answers: 2: The ORDER BY clause does sort data in ascending, not descending order, by default. 3: The ORDER BY clause must be after the WHERE clause in the SQL statement. 4: The ORDER BY clause is executed on the server side as the whole SQL statement is. 6: The ORDER BY clause is executed last in the query execution, after results are limited with the WHERE and GROUP BY clause conditions. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 56-61 Chapter 2: Limiting, Sorting, and Manipulating Return Data
|