Prev Question
Next Question

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

5a33f5b8d1641 - Which Transact-SQL query should you use?

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.

5a33f5b8f0f06 - Which Transact-SQL query should you use?

Which Transact-SQL query should you use?

A.
SELECT OrderId, OrderDate, Amount, Name, Country
FROM Orders
INNER JOIN Customers
ON 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’, CountryAS `Customers/Country’, OrderId, OrderDate, Amount
FROM Orders
INNER JOIN Customers
ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
FOR XML PATH (`Customers’

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *