Multiple choice technology databases

Which two statements are true regarding the ORDER BY clause?

  1. The sort is in ascending by order by default

  2. The sort is in descending order by default

  3. The ORDER BY clause must precede the WHERE clause.

  4. The ORDER BY clause is executed on the client side.

  5. The ORDER BY clause comes last in the SELECT statement.

  6. The ORDER BY clause is executed first in the query execution.
Reveal answer Fill a bubble to check yourself
A,E Correct answer
Explanation

The ORDER BY clause sorts results in ascending order (ASC) by default. It is positioned last in the SELECT statement structure, after WHERE, GROUP BY, and HAVING clauses. Options B, C, D, and F are incorrect - ORDER BY does not default to descending, must come after WHERE, executes on the server, and is not executed first.

Keep practicing — related questions