BIS 345 MENTOR Keep Learning /bis345mentor.com BIS 345 MENTOR Keep Learning /bis345mentor.com | Page 13

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;
SELECT Sum(OrderTotal)
FROM OrderTable
GROUP BY OrderTotal;
SELECT Rollup(OrderTotal)
FROM OrderTable;
Question 10.10. (TCO 4) Assume you have two queries. The first query
selects its data using a join involving five tables. The second query
selects its data using a join involving three tables. Which of the queries
would run faster, all other things being equal? (Points : 5)
The first query will run slower than the second query.
The second query will run slower than the second query.
The queries will run at the same speed.
All of the above