Oracle
1Z0-047 · Question #37
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 FROM employees. 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?
Options
- ASELECTfirst_name, salary
- BSELECTfirst_name, salary
- CSELECT first_name, salary
- DSELECT first_name, salary FROM employees
How the community answered
(48 responses)- A2% (1)
- B10% (5)
- C6% (3)
- D81% (39)
Community Discussion
No community discussion yet for this question.