Which Of The Following Function Returns True In The Following #187

Which of the following function returns true in the following code?</p> <pre><code class="language-sql">DECLARE @parent HierarchyId = (SELECT Node FROM H WHERE Name = 'Thuru') DECLARE @parentNodeLevel int = (select NodeLevel from h where name = 'Thuru') SELECT Node.ToString() AS NodeText, * FROM H WHERE Node.IsDescendantOf(@parent) = 'TRUE' AND Node != @parent AND NodeLevel = @parentNodeLevel + 1</code></pre>

This multiple choice question (MCQ) is related to the book/course gs gs116 Microsoft SQL Server. It can also be found in gs gs116 SQL Server Beyond Relational - Hierarchies - Quiz No.1.

DECLARE @parent HierarchyId = (SELECT Node FROM H WHERE Name = 'Thuru') DECLARE @parentNodeLevel int = (select NodeLevel from h where name = 'Thuru') SELECT Node.ToString() AS NodeText, *  FROM H WHERE Node.IsDescendantOf(@parent) = 'TRUE' AND Node != @parent AND NodeLevel = @parentNodeLevel + 1