Online Tutorials & Training Materials | STechies.com
Register Login

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

Sonia Barwar || 05 Mar 2008 5:08 pm || 0

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

A. The sort is in ascending order by default

B. The sort is in descending order by default

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

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

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

F. The ORDER BY clause is executed first in the query execution.

Answer: AE

  • A. The sort is in ascending order by default
  • E. The ORDER BY clause comes last in the SELECT statement