adplus-dvertising
frame-decoration

Question

Which of the following function will be used in the following code for moving nodes? 
DECLARE @newParent HierarchyId = (SELECT Node FROM H WHERE name = 'Johnny')
UPDATE H SET Node = Node.__________(Node.GetAncestor(1),@newParent)
WHERE Name = 'S1'

a.

GetReparentedVal

b.

GetReparentedValue

c.

GetValue

d.

None of the mentioned

Posted under SQL Server

Answer: (b).GetReparentedValue

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of the following function will be used in the following code for moving nodes?
Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the following code will not throw an error?

View solution

Q. Which of the reasons will force you to use XML data model in SQL Server?

View solution

Q. Which of the following is not a XML storage option?

View solution

Q. The choice of XML technology, native XML versus XML view, generally depends upon the following factors?

View solution

Q. In which of the following scenario, using XML native storage would be inappropriate?

View solution

Q. XML View Technology is useful in the following situations?

View solution

Q. What is the hybrid model in SQL Server?

View solution

Q. Reasons to use native XML features in SQL Server instead of managing your XML data in the file system would be:

View solution

Q. Which of the following part of the XML data stored in an XML column is very important for locking?

View solution

Q. XML datatype was introduced in which of the following versions of SQL Server?

View solution

Q. Which of the following feature of SQL Server was used before XML technology for semi structured data?

View solution

Q. What are Catalog Views for XML?

View solution

Q. Which of the following following is used for retrieving XML Schema Collections?

View solution

Q. What is index type for XML index entries?

View solution

Q. The space use of XML indexes can be found in the table-valued function named?

View solution

Q. Contents of sys.xml_schema_collections are _____________

View solution

Q. Which of the following statement would import additional schema or schema components into an existing collection object?

View solution

Q. Which operation cannot be performed on XML schema collection?

View solution

Q. Can we use untyped XML data type in the following situations?

View solution

Q. Point out the wrong statement.

View solution
View All MCQs on SQL Server

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...