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 )