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
is101, followed by employees up to one level below him or her in the hierarchy.
B.
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.
C.
It would return a hierarchical output starting with the employee whose EMPLOYEE_ID is
101, followed by his or her peers.
D.
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.
Explanation: