DRAG DROP
You use Microsoft SQL Server 2012 to develop a database that has two tables named Div1Cust and
Div2Cust.
Each table has columns named DivisionID and CustomerId . None of the rows in Div1Cust exist in
Div2Cust.
You need to write a query that meets the following requirements:
The rows in Div1Cust must be combined with the rows in Div2Cust.
The result set must have columns named Division and Customer.
Duplicates must be retained.
Which three Transact-SQL statements should you use? (To answer, move the appropriate
statements from the list of statements to the answer area and arrange them in the correct order.)
Answer: 
O_o
0
0
I think it’s: 5, 6, 2.
5: Because you first select the Div1Cust table and use the appropriate aliases for the columns.
6: Because “None of the rows in Div1Cust exist in Div2Cust” so you don’t need a more heavy UNION that applies a distinct.
2: You select the right columns from Div2Cust
0
0
yes that’s right
0
0
This picture from the next question. And answer placed there to.
0
0
5-6-2
0
0
In my estimation, aiotestking.com does a good job of covering topics like this! While sometimes deliberately polemic, the material posted is generally well-written and stimulating.
healthierway.tumblr.com
0
0
SELECT DivisionID AS Division, CustomerID AS Customer
FROM Div1Cust
UNION ALL
SELECT DivisionID, CustomerID
FROM Div2Cust
0
0
What’s more, part of that new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0