Oracle
1Z0-071 · Question #143
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…
The correct answer is D. It displays all cities in ascending order, within which the last names are further sorted in. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AIt displays all cities in descending order, within which the last names are further sorted in
- BIt fails because a column alias cannot be used in the ORDER BY clause.
- CIt fails because a column number and a column alias cannot be used together in the ORDER BY
- DIt displays all cities in ascending order, within which the last names are further sorted in
How the community answered
(23 responses)- A13% (3)
- B4% (1)
- C4% (1)
- D78% (18)
Community Discussion
No community discussion yet for this question.