1Z0-071 Web TestEngine demo

Exit VCEDump 1Z0-071 Oracle Database SQL
Question 38 of 63
0% complete
Q38 Single choice

Examine the description of the EMPLOYEES table:

Question 38 diagram

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?

Question 38 diagram

Sign in to mark questions

Sign in to save marked questions and return to this demo.

Sign in