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:
Is this the form of the question that was originally used by Oracle?
It seems misleading.
Because C. “It is possible to retrieve data only in top-down hierarchy.” would be correct, since it is entirely possible to retrieve data in a way that would force the data to be in top-down fashion exlusively.
However, if the original statement would have been
1) “It is [u]only[/u] possible to retrieve data in top-down hierarchy.” or
2) “It is possible to retrieve data in top-down hierarchy [u]only[/u].”,
in these cases the statement C. would be wrong.