Oracle
1Z0-047 · Question #49
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?
Exhibit
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
(39 responses)- A10% (4)
- B3% (1)
- C82% (32)
- D5% (2)
Community Discussion
No community discussion yet for this question.