nerdexam
Oracle

1Z0-047 · Question #20

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

1Z0-047 question #20 exhibit

Options

  • AWHERE
  • BHAVING
  • CGROUP BY
  • DSTARTWITH
  • ECONNECT BY PRIOR

How the community answered

(32 responses)
  • A
    3% (1)
  • C
    9% (3)
  • D
    6% (2)
  • E
    81% (26)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice