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.
View the Exhibit and examine the details of the EMPLOYEES table.Evaluate the following SQL statements:Statement 1:SELECT
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am