Microsoft
70-433 · Question #161
You are the database developer for a Microsoft SQL Server 2008 database that contains tables named order and product. The tables have the following definitions: You need to write a query that will…
The correct answer is C. Option C. See the full explanation below for the reasoning.
Question
You are the database developer for a Microsoft SQL Server 2008 database that contains tables named order and product. The tables have the following definitions:
You need to write a query that will extract a valid XML result set of all ordered products. You also need to ensure that the query conforms to the following schema:
Which SQL query should you use?
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(52 responses)- A4% (2)
- B10% (5)
- C83% (43)
- D4% (2)
Community Discussion
No community discussion yet for this question.