What would be the result execution?

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?
A. It displays all cities in descending order, within which the last names are further sorted in descending order
B. It fails because a column alias cannot be used in the ORDER BY clause,
C. It fails because a column number and a column alias cannot be used together in the ORDER BY clause,
D. It displays all cities in ascending order, within which the last names are further sorted in descending order.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.