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