Oracle Exam 1Z0-082 Topic 8 Question 82 Discussion

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

Question #: 82
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, B, C

https://antognini.ch/2016/10/whats-the-difference-between-row-migration-and-row-chaining/

by Lenna at Nov 26, 2023, 06: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

Devorah

2 days ago

E) WHERE city IN (*%AN%') is an interesting option, but I'm not sure it's the right one. Shouldn't we be using LIKE instead of IN for the city column?

upvoted 0 times

...

Heidy

3 days ago

D) WHERE city = =%AN%' seems a bit weird to me. Why the double equals sign and the single quotes around %AN%? I'm leaning towards C) WHERE city LIKE *%AN%*.

upvoted 0 times

...

Larue

6 days ago

I'm going with B) ORDER BY 1, 2. It's more concise and straightforward, and I don't see any issues with it.

upvoted 0 times

...

Susana

11 days ago

I think the answer is A) ORDER BY 1, LNAME DESC. The question states that we need to sort the cities in ascending order and the last names in descending order, which is exactly what this clause does.

upvoted 0 times

...