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

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
Question 11.11. (TCO 4) Assume you have two select queries that must
join two tables. The first query uses the INNER JOIN keyword, while the
other accomplishes the join using the WHERE clause. Which query will
be more likely to run faster - the first query or the second query? (Points
: 5)
The first query will run slower than the second query.
The second query will run slower than the first query.
The queries will run at the same speed.
All of the above