Which Of The Following Function Will Be Used In The Following #189

Which of the following function will be used in the following code for moving nodes?</p> <pre><code class="language-sql">DECLARE @newParent HierarchyId = (SELECT Node FROM H WHERE name = 'Johnny') UPDATE H SET Node = Node.__________(Node.GetAncestor(1),@newParent) WHERE Name = 'S1' </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 @newParent HierarchyId = (SELECT Node FROM H WHERE name = 'Johnny') UPDATE H SET Node = Node.__________(Node.GetAncestor(1),@newParent) WHERE Name = 'S1'