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
wellformed
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.)
A.
FOR BROWSE
B.
FOR XML RAW
C.
FOR XML PATH
D.
FOR XML EXPLICIT