70-461 Question 2

You develop 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 not include customers who have not placed any orders.Which Transact-SQL query should you use?

A. SELECT CustomerName, OrderDate
FROM Customers
LEFT OUTER JOIN Orders
ON Customers.CuscomerlD = Orders.CustomerId
B. SELECT CustomerName, OrderDate
FROM Customers
RIGHT OUTER JOIN Orders
ON Customers.CustomerID = Orders.CustomerId
C. SELECT CustomerName, OrderDate
FROM Customers
CROSS JOIN Orders
ON Customers.CustomerId = Orders.CustomerId
D. SELECT CustomerName, OrderDate
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 2

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

Recent Post