Oracle Exam 1Z0-071 Topic 6 Question 16 Discussion

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

Question #: 16
Topic #: 6

[All 1Z0-071 Questions]

Examine the description of the EMPLOYERS table:

Examine these requirements:

Disable the manager ID and salary of the lowest paid employees for that manager.

Exclude anyone whose manager is not known.

Exclude any managers where the minimum salary is 6000 or less.

Sort the output by minimum salary with the highest salary shown first.

Which statement will do this?

ASELECT manager_id, MTN(salary)
FROM employees
WHERE manager_ id IS NOT NULL
GROUP BY manager_id
HAVING MlN (salary) > 6000
ORDER BV MlN (salary);

BSELECT managar_id, MIN (salary)
FROM employees
HAVING MIN(salary) > 6000
WHERE manager_id IS NOT NULL
GROUP BY manager_id
ORDER BY MTN(salary) DESC;

CSELECT manager_id, HTN(salary)
FROM employees
WHERE manager_id IS NOT NULL
HAVING MIN (salary) > 6000
GROUP BY manager_id
ORDEU BY MIN (salary) DESC;

DSELECT manager_id, MIN(salary)
FROM employees
WHERE manager_id IS NOT NULL
AND MIN(salary) > 6000
GROUP BY manager_id
ORDER BY MlN (salary) DESC;

Show Suggested Answer

Suggested Answer: A

by Mitsue at May 04, 2022, 01:03 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!