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

The correct answer is A. The sort is in ascending by order by default. E. The ORDER BY clause comes last in the SELECT statement. 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 B: The ORDER BY clause does sort data in ascending, not descending order, by default. C: The…

Restricting and Sorting Data

Question

Options

AThe sort is in ascending by order by default.
BThe sort is in descending order by default.
CThe ORDER BY clause must precede the WHERE clause.
DThe ORDER BY clause is executed on the client side.
EThe ORDER BY clause comes last in the SELECT statement.
FThe ORDER BY clause is executed first in the query execution.

How the community answered

(36 responses)

A
75% (27)
B
3% (1)
C
14% (5)
D
6% (2)
F
3% (1)

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 B: The ORDER BY clause does sort data in ascending, not descending order, by default. C: The ORDER BY clause must be after the WHERE clause in the SQL statement. D: The ORDER BY clause is executed on the server side as the whole SQL statement is. F: The ORDER BY clause is executed last in the query execution, after results are limited with the WHERE and GROUP BY clause conditions.

Topics

#ORDER BY#default ascending sort#clause position#SELECT statement structure

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice