The ____ clause allows a hierarchical query to begin displaying within a hierarchical structure,with a specified column and value.
A) LEVEL
B) PRIOR
C) START WITH
D) FIRST

Question

Quizplus · Accepted Answer

The START WITH clause allows a hierarchical query to specify the root row(s) of the hierarchy. It identifies the column(s) and value(s) of the ancestor(s) upon which the hierarchy will be based. The LEVEL clause specifies the depth of a node in the hierarchy, and the PRIOR clause specifies the relationship between parent and child nodes. There is no FIRST clause in hierarchical queries.

The ____ Clause Allows a Hierarchical Query to Begin Displaying