You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.)



You need to display rows from the Orders table for the Customers row having the CustomerId value set to 1 in the following XML format.



Which Transact-SQL query should you use?

A.

SELECT OrderId, OrderDate

, Amount, Name, Country FROM OrdersINNER

JOIN CustomersON Orders.CustomerId = Customers-CustomerId

WHERE Customers.CustomerId = 1

FOR XML RAW

B.

SELECT OrderId, OrderDate, Amount, Name, Country

FROM Orders INNER JOIN Customers

ON Orders.CustomerId =

Customers.CustomerId

WHERE Customers.CustomerId = 1

FOR XML RAW, ELEMENTS

C.

SELECT OrderId, OrderDate, Amount, Name, Country

FROM Orders

INNER JOIN Customers

ON Orders.CustomerId = Customers.CustomerId

WHERE Customers.CustomerId = 1

FOR XML AUTO

D.

SELECT

OrderId, OrderDate, Amount, Name, Country

FROM Orders

INNER JOIN Customers

ON Orders.CustomerId = Customers.CustomerId

WHERE Customers.CustomerId= 1

FOR XML AUTO, ELEMENTS

E.

SELECT Name, Country, OrderId, OrderDate, Amount

FROM Orders

INNER JOIN Customers

ON Orders.CustomerId= Customers.CustomerId

WHERE Customers.CustomerId= FOR XML AUTO

F.

SELECT Name, Country, Crderld, OrderDate, Amount

FROM Orders

INNER JOIN Customers

ON Orders.CustomerId= Customers.CustomerId

WHERE Customers.CustomerId= FOR XML AUTO,

ELEMENTS

G.

SELECT Name AS `@Name, Country AS `@Country, OrderId, OrderDate, Amount

FROM Orders

INNER JOIN Customers

ON Orders.CustomerId= Customers.CustomerId

WHERE Customers.CustomerId = 1

FOR XML PATH (`Customers)

H.

SELECT Name AS `Customers/Name,

Country

AS `Customers/Country, OrderId, OrderDate, Amount

FROM Orders

INNER JOIN Customers

ON Orders.CustomerId= Customers.CustomerId

WHERE Customers.CustomerId= 1

FOR XML PATH (`Customers

)