Oracle
1Z0-047 · Question #262
View the Exhibit and examine the structure of the EMPLOYEES table. You want to retrieve hierarchical data of the employees using the top-down hierarchy. Which SQL clause would let you choose the…
The correct answer is E. CONNECT BY PRIOR. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the EMPLOYEES table. You want to retrieve hierarchical data of the employees using the top-down hierarchy. Which SQL clause would let you choose the direction to walk through the hierarchy tree?
Exhibit
Options
- AWHERE
- BHAVING
- CGROUP BY
- DSTART WITH
- ECONNECT BY PRIOR
How the community answered
(17 responses)- B6% (1)
- D12% (2)
- E82% (14)
Community Discussion
No community discussion yet for this question.
