Exam 1z0-082 topic 1 question 115 discussion

Actual exam question from Oracle's 1z0-082

Question #: 115
Topic #: 1

Examine the description of the MEMBERS table:

Examine the partial query:

SELECT city, last_name 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. WHERE city = '%AN%'
C. WHERE city LIKE '%AN%'
D. ORDER BY last_name DESC, city ASC
E. WHERE city IN ('%AN%')
F. ORDER BY 1, LNAME DESC

Show Suggested Answer

Suggested Answer: CF 🗳️

by PrasenC at Feb. 15, 2023, 12:14 p.m.

Comments

Submit Cancel

auwia

7 months ago

Selected Answer: CF

The base! Part V :-)

upvoted 3 times

...

RaNik69

8 months, 2 weeks ago

Selected Answer: CF

c f are correct

upvoted 2 times

...

Juv07

11 months, 2 weeks ago

The good answers is C,F

upvoted 3 times

...

PrasenC

11 months, 3 weeks ago

If the order is not specified, ASC is the default.

upvoted 1 times

...

PrasenC

11 months, 3 weeks ago

Selected Answer: CF

Refer: https://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqlj13658.html#:~:text=If%20the%20order%20is%20not%20specified%2C%20ASC%20is%20the%20default.&text=Specifies%20that%20the%20results%20should%20be%20returned%20in%20descending%20order.&text=Specifies%20that%20NULL%20values%20should%20be%20returned%20before%20non%2DNULL%20values.&text=Specifies%20that%20NULL%20values%20should%20be%20returned%20after%20non%2DNULL%20values. If the order is not specified, ASC is the default.

upvoted 3 times

...

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 115 discussion

Comments

auwia

RaNik69

Juv07

PrasenC

PrasenC

SY0-701