Oracle
1Z0-047 · Question #157
View the Exhibit and examine the structure of the EMPLOYEES table. You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first…
The correct answer is B. SELECT m.last_name "Manager", e.last_name "Employee" FROM employees m JOIN employees e. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the EMPLOYEES table. You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAME of the managers and the second column would have LAST_NAME of the employees. Which SQL statement would you execute?
Exhibit
Options
- ASELECT m.last_name "Manager", e.last_name "Employee" FROM employees m JOIN employees e
- BSELECT m.last_name "Manager", e.last_name "Employee" FROM employees m JOIN employees e
- CSELECT m.last_name "Manager", e.last_name "Employee" FROM employees m JOIN employees e
- DSELECT m.last_name "Manager", e.last_name "Employee" FROM employees m JOIN employees e
How the community answered
(52 responses)- A6% (3)
- B75% (39)
- C4% (2)
- D15% (8)
Community Discussion
No community discussion yet for this question.