047-171

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

Peer:同等

Answer: C

PRIOR 在的那边是父节点

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718972/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11312660/viewspace-718972/