Oracle Exam 1Z0-071 Topic 13 Question 94 Discussion

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

Question #: 94
Topic #: 13

[All 1Z0-071 Questions]

Examine this statement:

SELECT last name

FROM employees

ORDER BY CASE WHEN salary = (SELECT MAX(salary) FROM employees)

THEN 'A'

ELSE last_ name

END ,last_name DESC;

Which two statements are true?

AThe names of employees earning the maximum salary will appear first in descending order.

BThe names of employees earning the maximum salary will appear first In ascending order.

CAll remaining employee names will appear in ascending order.

DAll remaining employee names will appear in an unspecified order.

EAll remaining employee names will appear in descending order.

FThe names of employees earning the maximum salary will appear first in an unspecified order.

Show Suggested Answer

Suggested Answer: C

by Lindy at Jun 01, 2024, 05:21 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Denny

1 days ago

This is a tricky one! I can see how the CASE statement could be interpreted in different ways, but I'm leaning towards option A. Sorting the maximum salary employees first in descending order makes the most sense to me.

upvoted 0 times

...

23 days ago

The statement is definitely selecting the employees with the maximum salary and sorting them in descending order. The rest of the employees will be sorted by their last name in descending order as well. Option A is the correct answer.

upvoted 0 times

Elina

5 days ago

So, the remaining employees will be sorted by their last name in descending order too.

upvoted 0 times

...

Eric

8 days ago

I agree, the statement is selecting employees with the maximum salary and sorting them in descending order.

upvoted 0 times

...

Malissa

9 days ago

I think option A is correct.

upvoted 0 times

...