) Question 5 10 pts Which one of the following statements generates the temporary columns shown in the result set below?

[answerhappygod]

Question 5 10 Pts Which One Of The Following Statements Generates The Temporary Columns Shown In The Result Set Below 1 (132.85 KiB) Viewed 43 times

) Question 5 10 pts Which one of the following statements generates the temporary columns shown in the result set below? Results Messages ID PRICE PER Quantity 1 10248 14.00 12 2 10248 9.80 10 3 10248 34.80 5 4 10249 18.60 9 5 10249 42.40 40 6 10250 7.70 10 O SELECT OrderID AS ID, UnitPrice AS [PRICE PER), Quantity From [Order Details]; O SELECT OrderID AS ID, UnitPrice AS PRICE PER, Quantity From [Order Details]; O SELECT Order ID AS ID, UnitPrice AS [PRICE PER), Quantity From (Order Details]; O SELECT OrderID AS ID, UnitPrice AS [PRICE PER), Quantity From Order Details; Question 6 10 pts Which of the following statements displays all orders in the orders table with a Null shipping date? Results Messages Order D CustomerID EmployeeID Order Date Required Date Shipped Date NULL 1 11008 ERNSH 7 2 RANCH 6 11019 3 11039 LINOD 1998-04-08 00:00:00.000 1998-04-13 00:00:00.000 1998-04-21 00:00:00.000 1998-04-22 00:00:00.000 1998-04-23 00:00:00.000 1998-05-06 00:00:00.000 1998-05-11 00:00:00.000 NULL 1998-05-19 00:00:00.000 NULL 1998-05-20 00:00:00.000 NULL 1 4 4 5 11040 GREAL BOTTM LAMAI 11045 6 1998-05-21 00:00:00.000 NULL 1998-05-25 00:00:00.000 NULL 6 11051 7 1998-04-27 00:00:00.000 O SELECT * FROM Orders WHERE Shipped Date = NULL; SELECT * FROM Orders WHERE ShippedDate is 'NULL'; FROM Orders WHERE Shipped Date is NULL; WHERE ShippedDate is NULL FROM Orders; O O SELECT * O SELECT *

10 pts Question 7 Which one of the following statements eliminates the duplicate rows from displaying in the result set? Results Messages Country 1 Argentina 2 Austria 3 Belgium 4 Brazil 5 Canada 6 Denmark O SELECT Country FROM Customers ORDER BY Country: O SELECT Country FROM Customers ORDER BY DISTINCT Country: 10 pts O SELECT DISTINCT Country FROM Customers ORDER BY Country: O SELECT DISTINCT Country FROM Customers DISTINCT BY Country: Question 8 Which of the following statements produces the result set below? Results Messages Full Name 1 Nancy Davolio 2 Andrew Fuller 3 Janet Leverling 4 Margaret Peacock 5 Steven Buchanan O SELECT FirstName+ LastName AS [Full Name] FROM Employees; O SELECT FirstName + "' + LastName AS [Full Name] FROM Employees; O SELECT FirstName+ LastName AS FullName FROM Employees; O SELECT 'FirstName' + 'LastName" AS FullName FROM Employees;