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.