Latest And Actual 70-461 Exam Dumps | 70-461 Study Material Dumps

Question No : 10

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerID. You need to create a query that meets the following requirements:

- Returns the CustomerName for all customers and the OrderDate for any
orders that they have placed.
- Results must include customers who have not placed any orders.

Which Transact-SQL query should you use?

A. SELECT CustomerName, OrderDateFROM Customers RIGHT OUTER JOIN Orders ON Customers.
CustomerID = Orders.CustomerID

B. SELECT CustomerName, CrderDateFROM Customers JOIN Orders ON
Customers.CustomerID = Orders.CustomerID

C. SELECT CustomerName, OrderDateFROM Customers CROSS JOIN Orders ON Customers.CustomerID
= Orders.CustomerID

D. SELECT CustomerName, OrderDateFROM Customers LEFT OUTER JOIN Orders ON Customers.
CustomerID = Orders.CustomerID

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ms177634.aspx