You administer a Microsoft SQL Server 2012 databasenamed ContosoDb. Tables are defined as shown in the
exhibit. (Refer to the Exhibit.)
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.
<CUSTOMERS Name=”Customer A” Country=”Australia”>
<ORDERS OrderID=”1″ OrderDate=”2001-01-01″ Amount=”3400.00″ />
<ORDERS OrderID=”2″ OrderDate=”2002-01-01″ Amount=”4300.00″ />
</CUSTOMERS>
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’)
Explanation:
Verified answer as correct.
G
0
0
E is correct. I tested.
1
0
E is correct..
1
0
E is giving following answer when i tested
and G is giving following answer
1
2012-01-01T00:00:00
3400
2
2002-01-01T00:00:00
4300
0
0
E is correct, here when i pasted xml formated it did not print
0
0
no, its E
0
0
Wrong, wrong, wrong… Its G:
For anyone that wants to test on a test environment:
use xmldb
go
create table Customers (
customerid int NOT NULL,
name varchar(255) NULL,
country varchar(255) null,
PRIMARY KEY (customerid)
)
go
use xmldb
go
create table Orders (
orderid int NOT NULL,
customerid int NOT NULL,
orderdate date NULL,
amount int null,
PRIMARY KEY (orderid)
)
go
use xmldb
go
Insert Orders values (100,1,’2002-01-01′,2000)
go
use xmldb
go
Insert Orders values (101,1,’2002-01-02′,4000)
go
use xmldb
go
Insert Customers values (1,’Jose Silva’,’Brazil’)
go
use xmldb
go
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’)
0
0
actually the answer is E…i tested you code,but it’s wrong.
0
0
OPTION E —–CORRECT ANSWER
OPTION G
100
2002-01-01
2000
101
2002-01-02
4000
0
0
Besides, part of the new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0