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

Marguerita

1 months ago

Ah, the old 'trick question' strikes again! But I think I've got it figured out. Option A is the way to go - the maximum salary employees will be first in descending order, and the rest will follow suit. *winks* Gotta love these SQL puzzles, don't you?

upvoted 0 times

Destiny

7 days ago

Yeah, I think so too. It's a clever way to sort the data based on salary.

upvoted 0 times

...

Dana

13 days ago

I agree with you, option A is correct. The employees with the maximum salary will be listed first in descending order.

upvoted 0 times

...

Andra

1 months ago

I'm going to have to go with option A on this one. The CASE statement is clearly designed to prioritize the employees with the maximum salary, and the DESC keyword at the end seals the deal. *chuckles* I wonder if the exam writer was feeling a bit mischievous with this one.

upvoted 0 times

Mitsue

3 days ago

Yeah, option A makes the most sense. The exam writer definitely wanted to test our understanding of SQL queries with this one.

upvoted 0 times

...

Herschel

3 days ago

Yeah, option A makes the most sense. The exam writer definitely tried to throw us off with this one.

upvoted 0 times

...

Paola

4 days ago

I think you're right, the CASE statement is specifically sorting employees with the maximum salary first. It's a tricky question for sure.

upvoted 0 times

...

Ezekiel

13 days ago

I think you're right. The CASE statement is specifically sorting employees with the maximum salary first.

upvoted 0 times

...

Julio

13 days ago

I agree with you, option A seems to be the correct choice. The DESC keyword definitely indicates a descending order.

upvoted 0 times

...

Vicente

27 days ago

I agree, option A seems to be the correct choice. The DESC keyword definitely indicates a descending order.

upvoted 0 times

...

Denny

2 months 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

Marti

27 days ago

Yeah, option A seems to be the most accurate choice based on the query provided.

upvoted 0 times

...

Sage

1 months ago

I agree with you. That seems like the most logical interpretation of the CASE statement in this query.

upvoted 0 times

...

Tora

1 months ago

I think option A is correct. It makes sense to sort the employees earning the maximum salary first in descending order.

upvoted 0 times

...

Otis

2 months ago

Hmm, I'm not so sure about this one. The CASE statement seems a bit convoluted, but I think the employees with the maximum salary will appear first in descending order. Let me double-check the options.

upvoted 0 times

Clemencia

2 months ago

I agree, the names of employees earning the maximum salary will appear first in descending order.

upvoted 0 times

...

Karma

2 months ago

I think option A is correct.

upvoted 0 times

...

Kimberely

2 months ago

I'm not sure about option A. I think it could be option F because the query might return the names in an unspecified order.

upvoted 0 times

...

Mirta

2 months ago

I agree with Aliza. Option A makes sense because the query is ordering by the maximum salary in descending order.

upvoted 0 times

...

Aliza

2 months ago

I think option A is true because it says the names of employees earning the maximum salary will appear first in descending order.

upvoted 0 times

...

Michel

2 months 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