Oracle
1Z0-071 · Question #145
Examine the structure of the EMPLOYEES table. You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than…
The correct answer is C. SELECT last_name, hire_date, salary. See the full explanation below for the reasoning.
Question
Examine the structure of the EMPLOYEES table. You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000. Which query would retrieve the required result?
Options
- ASELECT last_name, hire_date, salary
- BSELECT last_name, hire_date, salary
- CSELECT last_name, hire_date, salary
- D(SELECT last_name, hire_date, salary
How the community answered
(51 responses)- A4% (2)
- B12% (6)
- C82% (42)
- D2% (1)
Community Discussion
No community discussion yet for this question.