Exam 1z0-071 topic 1 question 256 discussion

Actual exam question from Oracle's 1z0-071

Question #: 256
Topic #: 1

Examine the description of the EMPLOYEES table:

Examine these requirements:

1. Display the manager id and salary of the lowest paid employee for that manager.
2. Exclude anyone whose manager is not known.
3. Exclude any managers where the minimum salary is 6000 or less.
4. Sort the output by minimum salary with the highest salary shown first.

Which statement will do this?

Show Suggested Answer

Suggested Answer: D 🗳️

by kay000001 at Oct. 27, 2024, 10:09 a.m.

Comments

Submit Cancel

kay000001

2 months, 2 weeks ago

Sorry, my correct: A. is incorrect - the WHERE clause does not come after HAVING clause B. is technically incorrect, as the HAVING clause comes after the GROUP BY, however, in Oracle SQL, this can work and will produce the correct answer. C: is incorrect - cannot use an aggregated function straight in the WHERE clause D. Correct.

upvoted 1 times

...

kay000001

2 months, 2 weeks ago

Selected Answer: D

A. is incorrect - the WHERE clause does not come after HAVING clause B. is technically incorrect, as the HAVING clause comes after the GROUP BY, however, in Oracle SQL, this cannot work and will produce the correct answer. C: is incorrect - cannot use an aggregated function straight in the WHERE clause D. Correct.

upvoted 1 times

...

Exam 1z0-071 All Questions

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

Exam 1z0-071 topic 1 question 256 discussion

Comments

kay000001

kay000001

SY0-701