Microsoft
70-433 · Question #12
Your company's database contains Customers and Orders tables. You have been tasked to write a SELECT statement that outputs customer and order data as a valid and well-formed XML document. You are…
The correct answer is C. FOR XML PATH D. FOR XML EXPLICIT. See the full explanation below for the reasoning.
Question
Your company's database contains Customers and Orders tables. You have been tasked to write a SELECT statement that outputs customer and order data as a valid and well-formed XML document. You are required to mix attribute and element based XML within the document. You have determined that using the FOR XML AUTO clause will not be suitable. You need to identify the correct FOR XML clause to meet the requirement. Which FOR XML statement should you use? (Each correct answer represents a complete solution. Choose two.)
Options
- AFOR BROWSE
- BFOR XML RAW
- CFOR XML PATH
- DFOR XML EXPLICIT
How the community answered
(66 responses)- A5% (3)
- B12% (8)
- C83% (55)
Community Discussion
No community discussion yet for this question.