Oracle
1Z0-047 · Question #253
View the Exhibit and examine the structure of the EMPLOYEES table. You want to know the FIRST_NAME and SALARY for all employees who have the same manager as that of the employee with the first name…
The correct answer is D. SELECT first_name, salary. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the EMPLOYEES table. You want to know the FIRST_NAME and SALARY for all employees who have the same manager as that of the employee with the first name 'Neena' and have salary equal to or greater than that of 'Neena'. Which SQL statement would give you the desired result?
Exhibit
Options
- ASELECT first_name, salary
- BSELECT first_name, salary
- CSELECT first_name, salary
- DSELECT first_name, salary
How the community answered
(55 responses)- A5% (3)
- B11% (6)
- C2% (1)
- D82% (45)
Community Discussion
No community discussion yet for this question.