Oracle
1Z0-047 · Question #30
Which statements are true regarding the hierarchical query in Oracle Database 10g? (Choose all that apply.
The correct answer is B. Itis possible to retrieve data in top-down or bottom-up hierarchy. C. It is possible to remove an entire branch from the output of the hierarchical query. See the full explanation below for the reasoning.
Question
Which statements are true regarding the hierarchical query in Oracle Database 10g? (Choose all that apply.
Options
- AIt is possible to retrieve data only in top-down hierarchy.
- BItis possible to retrieve data in top-down or bottom-up hierarchy.
- CIt is possible to remove an entire branch from the output of the hierarchical query.
- DYou cannot specify conditions when you retrieve data by using a hierarchical query.
How the community answered
(46 responses)- A9% (4)
- B78% (36)
- D13% (6)
Community Discussion
No community discussion yet for this question.