Oracle
1Z0-061 · Question #201
Which two statements are true regarding the ORDER BY clause? (Choose two.)
The correct answer is B. It must be the last clause in the SELECT statement. E. You can specify a combination of numeric positions and column names in this clause. See the full explanation below for the reasoning.
Question
Which two statements are true regarding the ORDER BY clause? (Choose two.)
Options
- AIt is executed first in the query execution.
- BIt must be the last clause in the SELECT statement.
- CIt cannot be used in a SELECT statement containing a HAVING clause.
- DYou cannot specify a column name followed by an expression in this clause.
- EYou can specify a combination of numeric positions and column names in this clause.
How the community answered
(31 responses)- A3% (1)
- B77% (24)
- C13% (4)
- D6% (2)
Community Discussion
No community discussion yet for this question.