Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 25 of 50

Marks: +1, -0

Examine the structure of the MEMBERS table: (Choose the best answer.)

Examine the SQL statement:
SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC;
What would be the result execution?

It displays all cities in descending order, within which the last names are further sorted in descending order.
It fails because a column alias cannot be used in the ORDER BY clause.
It fails because a column number and a column alias cannot be used together in the ORDER BY clause.
It displays all cities in ascending order, within which the last names are further sorted in descending order.

Go to Question:

Prev Question

Next Question