Which statements are true regarding the hierarchical query in Oracle Database 10g?

Which statements are true regarding the hierarchical query in Oracle Database 10g?
(Choose all that apply.)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *