Which statements are true regarding the hierarchical query in Oracle Database 10g?
(Choose all that apply.
A.
You cannot specify conditions when you retrieve data by using a hierarchical query.
B.
It is possible to remove an entire branch from the output of the hierarchical query.
C.
It is possible to retrieve data only in top-down hierarchy.
D.
It is possible to retrieve data in top-down or bottom-up hierarchy.
Explanation: