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
Question 12.12 . ( TCO 7 ) Which of the following file formats are used to import data into SSRS . ( Points : 5 ) CSV PDF