Which two statements are true regarding the output of this command?

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.)

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.



Leave a Reply 3

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


Ab Hin

Ab Hin

Answers: A & C