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)