Oracle Exam 1Z0-082 Topic 8 Question 65 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 65
Topic #: 8

Examine the description of the members table:

Examine the partial query:

SELECT city, last__name 1NAME FROM members

You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.

Which two clauses must you add to the query?

AORDER BY 1, LNAME DESC

BORDER BY 1, 2

CWHERE city LIKE *%AN%*

DWHERE city = =%AN%'

EWHERE city IN (*%AN%')

FORDER BY last_narae DESC, city ASC

Show Suggested Answer

Suggested Answer: A, C

by Selma at Oct 26, 2022, 09:32 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!