BIS 345 mentor Career Begins/bis 345mart.com BIS 345 mentor Career Begins/bis 345mart.com | Page 14

IS NULL None of the above
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)