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 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- 1
FOR XML AUTO
F.
SELECT Name, Country, Orderld, OrderDate, Amount
FROM Orders INNER JOIN Customers ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId= 1
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’)
It should be C
0
0
D – is right
0
0
D is the correct answer.
You need ELEMENTS to have the element-centric format. Have a look at this: https://msdn.microsoft.com/en-us/library/ms188273.aspx
0
0
the correct code for the requested XML format is as the following:
SELECT OrderId, OrderDate, Amount,
Name AS ‘Customers/Name’,
Country AS ‘Customers/Country’
FROM Orders INNER JOIN Customers
ON Orders.CustomerId= Customers.CustomerId
WHERE Customers.CustomerId = 1
FOR XML path(‘Orders’);
0
0
Answer is Option D:
Sample Code:
SELECT C.contactname, C.country, O.orderid, O.orderdate, O.freight
FROM Sales.Orders AS O
INNER JOIN Sales.Customers AS C
ON O.custid= C.custid
WHERE C.custid= 1
FOR XML AUTO, ELEMENTS;
Sample Result Set:
Allen, Michael
Germany
10643
2007-08-25T00:00:00
29.4600
10692
2007-10-03T00:00:00
61.0200
10702
2007-10-13T00:00:00
23.9400
10835
2008-01-15T00:00:00
69.5300
10952
2008-03-16T00:00:00
40.4200
11011
2008-04-09T00:00:00
1.2100
0
0
What’s more, part of the new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0