Which statement is true regarding the output for this command?

View the Exhibit and examine the structure of the EMPLOYEES table.
Evaluate the following SQL statement:
SELECT employee_id, last_name, job_id, manager_id
FROM employees
START WITH employee_id = 101
CONNECT BY PRIOR employee_id=manager_id;
Which statement is true regarding the output for this command?

View the Exhibit and examine the structure of the EMPLOYEES table.
Evaluate the following SQL statement:
SELECT employee_id, last_name, job_id, manager_id
FROM employees
START WITH employee_id = 101
CONNECT BY PRIOR employee_id=manager_id;
Which statement is true regarding the output for this command?

A.
It would return a hierarchical output starting with the employee whose
EMPLOYEE_ID is 101, followed by his or her peers.

B.
It would return a hierarchical output starting with the employee whose
EMPLOYEE_ID is 101, followed by the employee to whom he or she reports.

C.
It would return a hierarchical output starting with the employee whose
EMPLOYEE_ID is 101, followed by employees below him or her in the hierarchy.

D.
It would return a hierarchical output starting with the employee whose
EMPLOYEE_ID is101, followed by employees up to one level below him or her in the
hierarchy.



Leave a Reply 1

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