BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 15

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
Question 12.12. (TCO 7) Which of the following file formats are used to
import data into SSRS. (Points : 5)
CSV
PDF
SLN
docx
Question 13.13. (TCO 8) Name the security concept involves ensuring that
one person doesn't have control over too many steps in a process.(Points :
5)