Oracle
1Z0-047 · Question #173
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…
The correct answer is C. It would return a hierarchical output starting with the employee whose EMPLOYEE_ID is 101, followed. See the full explanation below for the reasoning.
Question
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?
Options
- AIt would return a hierarchical output starting with the employee whose EMPLOYEE_ID is 101, followed
- BIt would return a hierarchical output starting with the employee whose EMPLOYEE_ID is 101, followed
- CIt would return a hierarchical output starting with the employee whose EMPLOYEE_ID is 101, followed
- DIt would return a hierarchical output starting with the employee whose EMPLOYEE_ID is101, followed
How the community answered
(62 responses)- A15% (9)
- B5% (3)
- C74% (46)
- D6% (4)
Community Discussion
No community discussion yet for this question.