1. (TCO 1) Which of the following portions of an SQL Statement indicate the columns that should be included in the result set?(Points : 5) SELECT FROM WHERE INSERT Question 2.2. (TCO 1) Which of the following operators uses wildcard characters to search for patterns or characters in a character string?(Points : 5) SEARCH LIKE BETWEEN EQUAL TO Question 3.3. (TCO 1) Which of the following characters is used to merge the output of two columns into one? (Points : 5) AND PLUS + ; Question 4.4. (TCO 1) Which of the following would extract all rows containing the numbers 4 or 8? (Points : 5) WHERE number = 4 or number = 8 WHERE number BETWEEN 4 and 8 WHERE number = ‘4 or 8’ Where number = ‘4’ or ‘8’ Question 5.5. (TCO 1) Assume you have a table called CourseTable. You would like to extract all courses that were developed in June and July of 2008. Which of the following operators would be of most use to you in your WHERE clause? (Points : 5) BETWEEN LIKE IS NULL None of the above Question 6.6. (TCO 1) Given Professors table with LastName, FirstName, and MI fields, which of the following would select all fields from the table? (Points : 5) SELECT * FROM Professors; SELECT * Professors; SELECT Last Name, First Name, MI FROM Professors; SELECT * ALL 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 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) zroles Separation of duties Securing forms and reports Using views Question 14.14. (TCO 8) _____ is the process of creating ciphertext. (Points : 5) Passcoding Digital Certificate Symmetric Encryption Question 15.15. (TCO 9) Which of the following reports requires the reader to look at data in both column and row format? (Points : 5) Matrix Exception Tabular None of the above Question 16.16. (TCO 9) Assume you are creating a report which is sorted by class, and then by student within class. The class is considered the ____ column: (Points : 5) gross minor major None of the above Question 17.17. (TCO 9) Which date function will return the difference between two dates in the specified units? (Points : 5) DATEDIFFERENCE DATEPART DATEDIFF DATEADD Question 18.18. (TCO 10) Which of the following represent a popular report-writing tool that is not a Microsoft application? (Points : 5) Access Reports SSRS SSMS Crystal Reports Question 19.19. (TCO 10) Which of the following is NOT one of the formats available for reports? (Points : 5) XML HTML PDF XPDF Question 20.20. (TCO 2) Which date function will return the difference between two dates in the specified units? (Points : 5) DATEDIFFERENCE DATEPART DATEDIFF DATEADD Question 21.21. (TCO 2) Which of the following functions would you use to extract the year, month, or day records in the database? (Points : 5) Datepart Datediff Dateout Dateyear Question 22.22. (TCO 2) Which of the following functions would you use to extract characters from the middle of a string. (Points : 5) Left() Right() Middle() Substring() Question 23.23. (TCO 3) Which of the following aggregate functions can be used with any data type. (Points : 5) MAX SUM COUNT AVG Question 24.24. (TCO 5) When using the report server project wizard the most crucial step is _______. (Points : 5) selecting your data source naming your project selecting the location to save your project selecting the correct template Question 25.25. (TCO 5) SSRS uses all of the following types of extensions except ______. (Points : 5) data processing security delivery communication Question 26.26. (TCO 5) By default when we add a table to our report in Business Intelligence Development Studio, the table has _____ columns. (Points : 5) 2 3 4 5 Question 27.27. (TCO 5) You can use the ______ in Business Intelligence Development Studio to access the report items controls. (Points : 5) Design tab Toolbox Toolbar Preview tab Question 28.28. (TCO 7) The chart control used in SSRS is licensed from ______ software. (Points : 5) Dundas Adobe Apple Google Question 29.29. (TCO 7) ______ presents group data in a grid layout that’s capable of expanding both rows and columns. (Points : 5) Table Matrix List Dropdown Question 30.30. (TCO 6) A ____ parameter are used during the processing of the query. (Points : 5) Multidimensional Expressions (MDX) query report Multivalue parameters Question 31.31. (TCO 6) Which data source credentials option is considered an integrated security type. (Points : 5) Prompt for credentials Windows authentication Hard-code credentials No credentials Question 32.32. (TCO 6) ______ data source is used to dynamically choose the data source at runtime. (Points : 5) embedded shared unique expression Question 33.33. (TCO 3) Which of the following aggregate functions would not ignore null values. (Points : 5) Count AVG MAX Sum Question 34.34. (TCO 3) Which of the following is not a valid aggregate function. (Points : 5) DATEDIFFERENCE COUNT MAX MIN Question 35.35. (TCO 5) For the report server to use an extension, it must be ______. (Points : 5) configured linked to the server added to the report installed 36. (TCO 2) Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements: For each city, list the city name in all upper case characters along with the exchange part of the customer phone number (the first 3 digits). Include only preferred Part 1: Write the complete SQL statement needed to return the rows that meet these requirements. Part 2: What rows will be returned from this query? List the customer ID only of the rows to be returned. Part 3: What function did you use to extract the three-digit exchange? Why did you select this function? Rewrite the SQL using a different function to extract these characters. (Points : 25) Part 3: To extract the three-digit exchange I used the LEFT(Phone,3) funcion. 37. (TCO 3) Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements. For each city, list the name of the city, and the number of customers in that city. Include only those cities that have more than 1 customer in them. Order the data by city in descending order. tblCustomer: Part 1: SELECT City, COUNT(*) FROM tblCustomer GROUP BY City HAVING COUNT(*)>1 ORDER BY City DESC; Part 2: Did you select any filter clause(s)? (WHERE, HAVING) Justify your choice of filter(s). (Points : 25) 38. (TCO 6) Evaluate the Supplier List report below. Management requested this report so they can monitor the value and quantity of the stock on hand; a requirement of the report is to be able to match the product to the supplier. Part 1: Describe at least two enhancements that would make this report more readable to the user. Part 1: The two enhancements I would make would be: Part 2: Describe at least two features you would include that would add functionality to the report and improve its flexibility for the user. (Points : 25) Part 2: If I had to include two features to add functionality to the report and improve its flexibility they would be:
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer