70-461 Question 3

You develop a Microsoft SQL Server 2012 database that contains tables named
Customers and Orders. The tables are related by a column named Customer Id.You need to create a query that meets the following requirements:Returns the Customer Name for all customers and the Order Date for any or ders that they have placed.Results must not include customers who have not placed any orders.Which Transact-SQL query should you use?

A. SELECT Customer Name, Order Date FROM Customers LEFT OUTER JOIN Orders ON Customers.Cuscomer lD = Orders.CustomerId
B. SELECT Customer Name, Order Date FROM Customers RIGHT OUTER JOIN Orders ON Customers.Customer ID = Orders.CustomerId
C. SELECT Customer Name, Order Date FROM Customers CROSS JOIN Orders ON Customers.CustomerId = Orders.CustomerId
D. SELECT Customer Name, Order Date FROM Customers JOIN Orders ON Customers.CustomerId = Orders.CustomerId

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



Category: 70-461 Exam Questions

you are at 70-461 Question 3

For more questions you can browse 70-461 Exam Questions.

Recent Post