Microsoft
70-451 · Question #113
You are a database developer. You plan to design a database solution by using SQL Server 2008. You are writing a query that returns XML data from a table in a database. You need to ensure that your…
The correct answer is B. Use the PATH mode along with a ROOT directive. See the full explanation below for the reasoning.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. You are writing a query that returns XML data from a table in a database. You need to ensure that your result set is encapsulated within a root element. What should you do?
Options
- AUse the RAW mode along with an ELEMENTS directive.
- BUse the PATH mode along with a ROOT directive.
- CUse the EXPLICIT mode along with a TYPE directive.
- DUse the AUTO mode along with a ROOT directive.
How the community answered
(39 responses)- A10% (4)
- B79% (31)
- C3% (1)
- D8% (3)
Community Discussion
No community discussion yet for this question.