Which two statements are true regarding the ORDER BY clause? (Choose two.)
A.
You cannot specify a column name followed by an expression in this clause.
B.
You can specify a combination of numeric positions and column names in this clause.
C.
It is executed first in the query execution.
D.
It must be the last clause in the SELECT statement.
E.
It cannot be used in a SELECT statement containing a HAVING clause.
You retrieve sorted data by adding an ORDER BY clause to your SELECT statement. ORDER BY is always the last clause in a query.
http://www.oracle.com/technetwork/issue-archive/2012/12-may/o32sql-1541432.html
Test
B and D
How do we post new questions that have come out for 1z0-051 and 1z0-061?? Thanks