ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-171

047-171

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 10:41:28 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-167
下一篇: 047-172
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204335