View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the
following SQL statement: SELECT employee_id, last_name, job_id, manager_id, LEVEL
FROM employees START WITH employee_id = 101 CONNECT BY PRIOR
employee_id=manager_id ; Which two statements are true regarding the output of this
command? (Choose two.)
A.
The LEVEL column displays the level in the hierarchy at which the employee is placed
under the employee having the EMPLOYEE_ID 101
B.
The LEVEL column displays the number of employees in the hierarchy under the
employee having the EMPLOYEE_ID 101.
C.
The output would be in top-down hierarchy starting with EMPLOYEE_ID having value
101.
D.
The output would be in bottom-up hierarchy starting with EMPLOYEE_ID having value
101.
Answers are reversed.
A LEVEL column displays the level in the hierarchy. (http://docs.oracle.com/database/121/SQLRF/pseudocolumns001.htm#i1009261)
And the output is in top-down hierachy, as employee_id = manager_id is a connected in a way the displays the employee (first part) as the manager (second part) of those connected to this person.
You can find this in the official Oracle eKit by searching for the phrase “… CONNECT BY PRIOR employee_id = manager_id”.
Agreed
Yes, the answer is wrong, should be AC
Agreed! A and C