Which statement is true regarding the output of this SQL statement?

View the Exhibit and examine the description of the EMPLOYEES and DEPARTMENTS
tables. You want to display the LAST_NAME for the employees, LAST_NAME for the
manager of the employees, and the DEPARTMENT_NAME for the employees having 100
as MANAGER_ID. The following SQL statement was written: SELECT m.last_name
“Manager”, e.last_name “Employee”, department_name “Department” FROM employees m
JOIN employees e ON (m.employee_id = e.manager_id) WHERE e.manager_id=100 JOIN
departments d ON (e.department_id = d.department_id); Which statement is true regarding
the output of this SQL statement?

View the Exhibit and examine the description of the EMPLOYEES and DEPARTMENTS
tables. You want to display the LAST_NAME for the employees, LAST_NAME for the
manager of the employees, and the DEPARTMENT_NAME for the employees having 100
as MANAGER_ID. The following SQL statement was written: SELECT m.last_name
“Manager”, e.last_name “Employee”, department_name “Department” FROM employees m
JOIN employees e ON (m.employee_id = e.manager_id) WHERE e.manager_id=100 JOIN
departments d ON (e.department_id = d.department_id); Which statement is true regarding
the output of this SQL statement?

A.
The statement would provide the desired results.

B.
The statement would not execute because the self join uses the ON clause instead of the
USING clause.

C.
The statement would not execute because the ON clause is written twice.

D.
The statement would not execute because the WHERE clause is wrongly placed.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Ab Hin

Ab Hin

Answer is: D