Oracle
1Z0-047 · Question #22
View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT employee_id, last_name, job_id, manager_id, LEVEL FROM employees START WITH…
The correct answer is A. The output would be in top-down hierarchy starting with EMPLOYEE_ID having value 101. D. The LEVEL column displays the level in the hierarchy at which the employee is placed under the employee. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement:
SELECT employee_id, last_name, job_id, manager_id, LEVEL FROM employees START WITH employee_id = 101 CONNECT BY PRIOR employee_id=manager_id ; Which two statements are true regarding the output of this command? (Choose two.)
Exhibit
Options
- AThe output would be in top-down hierarchy starting with EMPLOYEE_ID having value 101.
- BThe output would be in bottom-up hierarchy starting with EMPLOYEE_ID having value 101.
- CThe LEVEL column displays the number of employees in the hierarchy under the employee having the
- DThe LEVEL column displays the level in the hierarchy at which the employee is placed under the employee
How the community answered
(39 responses)- A77% (30)
- B8% (3)
- C15% (6)
Community Discussion
No community discussion yet for this question.