Explanation:To change or remove a portion of the content in an XML variable or column, the modify() method can be used. 10. Why do we use exist method in Xquery ?
A. To determine if the XML data contains a certain node
B. To examine the XML and return back a scalar value
C. To Shred the XML nodes of the XML data into relational columns
D. To search inside xml data types
Answer:A
Explanation:To change or remove a portion of the content in an XML variable or column, the modify() method can be used. 10. Why do we use exist method in Xquery ?
A. To determine if the XML data contains a certain node B. To examine the XML and return back a scalar value C. To Shred the XML nodes of the XML data into relational columns D. To search inside xml data types
Explanation:exist() method is used to determine whether a query returns a nonempty result or not. Sanfoundry Global Education & Learning Series – SQL Server.