View the Exhibit and examine the details of the EMPLOYEES table.Evaluate the following SQL statements:Statement 1:SELECT

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

View the Exhibit and examine the details of the EMPLOYEES table.Evaluate the following SQL statements:Statement 1:SELECT

Post by answerhappygod »

View the Exhibit and examine the details of the EMPLOYEES table.Evaluate the following SQL statements:Statement 1:SELECT employee_id, last_name, job_id, manager_id FROM employees START WITH employee_id = 101CONNECT BY PRIOR employee_id = manager_id AND manager_id != 108;Statement 2:SELECT employee_id, last_name, job_id, manager_idFROM employees -WHERE manager_id != 108 -START WITH employee_id = 101 -CONNECT BY PRIOR employee_id = manager_id;Which two statements are true regarding the above SQL statements? (Choose two.)

A. Statement 2 would not execute because the WHERE clause condition is not allowed in a statement that has the START WITH clause.
B. The output for statement 1 would display the employee with MANAGERJD 108 and all the employees below him or her in the hierarchy.
C. The output of statement 1 would neither display the employee with MANAGERJD 108 nor any employee below him or her in the hierarchy.
D. The output for statement 2 would not display the employee with MANAGERJD 108 but it would display all the employees below him or her in the hierarchy.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply