BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com | Page 13

WHERE number = 4 or number = 8
WHERE number BETWEEN 4 and 8
WHERE number = '4 or 8'
Where number = '4' or '8'
Question 5.5. (TCO 1) Assume you have a table called CourseTable.
You would like to extract all courses that were developed in June and
July of 2008. Which of the following operators would be of most use to
you in your WHERE clause? (Points : 5)
BETWEEN
LIKE
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;