nerdexam
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

1Z0-047 question #262 exhibit

Options

  • AWHERE
  • BHAVING
  • CGROUP BY
  • DSTART WITH
  • ECONNECT BY PRIOR

How the community answered

(17 responses)
  • B
    6% (1)
  • D
    12% (2)
  • E
    82% (14)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice