Which statements are true regarding the hierarchical query in Oracle Database 10g?
(Choose all that apply.
A.
It is possible to retrieve data only in top-down hierarchy.
B.
It is 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.
D.
You cannot specify conditions when you retrieve data by using a hierarchical query.