Exam 1z0-071 topic 1 question 19 discussion

Actual exam question from Oracle's 1z0-071

Question #: 19
Topic #: 1

Examine the description of the MEMBERS table:

Examine the partial query:
SELECT city, last_name AS lname 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? (Choose two.)

A. ORDER BY 1, 2
B. ORDER BY 1, lname DESC
C. WHERE city IN ('%AN%')
D. WHERE city = '%AN%'
E. WHERE city LIKE '%AN%'
F. ORDER BY last_name DESC, city ASC

Show Suggested Answer

Suggested Answer: BE 🗳️

by apolodor1 at Nov. 28, 2022, 10:19 p.m.

Comments

Submit Cancel

pushpaksarode

3 months, 3 weeks ago

Selected Answer: BE

For '%%' or '_' we have to use LIKE, not "="

upvoted 1 times

...

Lee_jong_suk

7 months, 2 weeks ago

Option BE is right!

upvoted 2 times

...

randomArrow

8 months ago

Selected Answer: BE

EF cannot be right. As the question asks us to first sort by cities in the ascending order. Only then further the sorting requires for lastname is descending order. F does vice versa

upvoted 1 times

...