NodeLevel = @parentNodeLevel + 1
A. IsDescendantOf
B. DescendantOf
C. IsDescendant
D. None of the mentioned
Answer:A
NodeLevel = @parentNodeLevel + 1
A. IsDescendantOf B. DescendantOf C. IsDescendant D. None of the mentioned
Explanation:In the above query,immediate children is returned using the NodeLevel column (@parentNodeLevel + 1). And also notice that I have opted out the parent node because IsDescendantOf function includes the parent node as well in the result. 8. Which of the code deletes node H using hierarchial data type ?