Which Transact-SQL query should you run?

You administer a Microsoft SQL Server database named ContosoDb.

The database has the following schema collection:

The database has a table named ReceivedPurchaseOrders that includes an XML column named PurchaseOrder by using the above schema.

You need to set the requiresApproval attribute of the XML documents to false if they contain more than 50 items.

Which Transact-SQL query should you run?

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: D

Explanation:

Replace value of (XML DML) updates the value of a node in the document.

Example: — update text in the first manufacturing step

SET @myDoc.modify(‘

replace value of (/Root/Location/step[1]/text())[1]

with "new text describing the manu step"

‘);