BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 14

Question 6.6. (TCO 1) Given Professors table with LastName, FirstName,
and MI fields, which of the following would select all fields from the table?
(Points : 5)
SELECT * FROM Professors;
SELECT * Professors;
SELECT Last Name, First Name, MI FROM Professors;
SELECT * ALL
Question 7.7. (TCO 1) Which of the following would extract all rows
containing the numbers 10 or 20? (Points : 5)
WHERE number BETWEEN 10 and 20
WHERE number = 10 or number = 20
WHERE number = '10 or 20'
Where number = '10' or '20'
Question 8.8. (TCO 3) Which of the following statements would extract the
average price of all the products?
Assume you have a table with the following columns:
(Points : 5)
SELECT ProductID, Avg(UnitPrice)
FROM ProductTable
GROUP BYProductID;
SELECT Average(UnitPrice)
FROM ProductTable;
SELECT Avg(UnitPrice)
FROM ProductTable;
None of the above
Question 9.9. (TCO 3) Which of the following statements would the extract
the total value of all the orders?
Assume you have a table with the following columns:
(Points : 5)
SELECT Total(OrderTotal)
FROM OrderTable;
SELECT Sum(OrderTotal)
FROM OrderTable;