Microsoft
70-457 · Question #54
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…
The correct answer is E. SELECT Name, Country, OrderId, OrderDate, Amount. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ASELECT OrderId, OrderDate, Amount, Name, Country
- BSELECT OrderId, OrderDate, Amount, Name, Country
- CSELECT OrderId, OrderDate, Amount, Name, Country
- DSELECT OrderId, OrderDate, Amount, Name, Country
- ESELECT Name, Country, OrderId, OrderDate, Amount
- FSELECT Name, Country, Orderld, OrderDate, Amount
- GSELECT Name AS '@Name', Country AS '@Country', OrderId, OrderDate, Amount
- HSELECT Name AS'Customers/Name', Country AS 'Customers/Country', OrderId, OrderDate,
How the community answered
(36 responses)- C11% (4)
- D3% (1)
- E81% (29)
- H6% (2)
Community Discussion
No community discussion yet for this question.