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)\t\u00a0 \u00a0 \u00a0 \u00a0SELECT\t\u00a0 \u00a0 \u00a0 \u00a0FROM\t\u00a0 \u00a0 \u00a0 \u00a0WHERE\t\u00a0 \u00a0 \u00a0 \u00a0INSERT\u00a0\t\u00a0\t\u00a0\tQuestion 2.2. (TCO 1) Which of the following operators uses wildcard characters to search for patterns or characters in a character string?(Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0SEARCH\t\u00a0 \u00a0 \u00a0 \u00a0LIKE\t\u00a0 \u00a0 \u00a0 \u00a0BETWEEN\t\u00a0 \u00a0 \u00a0 \u00a0EQUAL TO\t\u00a0\t\u00a0\tQuestion 3.3. (TCO 1) Which of the following characters is used to merge the output of two columns into one? (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0AND\t\u00a0 \u00a0 \u00a0 \u00a0PLUS\t\u00a0 \u00a0 \u00a0 \u00a0+\t\u00a0 \u00a0 \u00a0 \u00a0;\u00a0\t\u00a0\t\u00a0\t\u00a0\tQuestion 4.4. (TCO 1) Which of the following would extract all rows containing the numbers 4 or 8? (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0WHERE number = 4 or number = 8\t\u00a0 \u00a0 \u00a0 \u00a0WHERE number BETWEEN 4 and 8\t\u00a0 \u00a0 \u00a0 \u00a0WHERE number = ‘4 or 8’\t\u00a0 \u00a0 \u00a0 \u00a0Where number = ‘4’ or ‘8’\u00a0\t\u00a0\t\u00a0\tQuestion 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)\t\u00a0 \u00a0 \u00a0 \u00a0BETWEEN\t\u00a0 \u00a0 \u00a0 \u00a0LIKE\t\u00a0 \u00a0 \u00a0 \u00a0IS NULL\t\u00a0 \u00a0 \u00a0 \u00a0None of the above\u00a0\t\u00a0\t\u00a0\tQuestion 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)\t\u00a0 \u00a0 \u00a0 \u00a0SELECT * FROM Professors;\t\u00a0 \u00a0 \u00a0 \u00a0SELECT * Professors;\t\u00a0 \u00a0 \u00a0 \u00a0SELECT Last Name, First Name, MI FROM Professors;\t\u00a0 \u00a0 \u00a0 \u00a0SELECT * ALL\t\u00a0\t\u00a0\tQuestion 7.7. (TCO 1) Which of the following would extract all rows containing the numbers 10 or 20? (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0WHERE number BETWEEN 10 and 20\t\u00a0 \u00a0 \u00a0 \u00a0WHERE number = 10 or number = 20\t\u00a0 \u00a0 \u00a0 \u00a0WHERE number = ’10 or 20′\t\u00a0 \u00a0 \u00a0 \u00a0Where number = ’10’ or ’20’\u00a0\t\u00a0\t\u00a0\t\u00a0\tQuestion 8.8. (TCO 3) Which of the following statements would extract the average price of all the products?\u00a0\tAssume you have a table with the following columns:\t\u00a0 (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0SELECT ProductID, Avg(UnitPrice)\tFROM ProductTable\tGROUP BYProductID;\t\u00a0 \u00a0 \u00a0 \u00a0SELECT Average(UnitPrice)\tFROM ProductTable;\t\u00a0 \u00a0 \u00a0 \u00a0SELECT Avg(UnitPrice)\tFROM ProductTable;\t\u00a0 \u00a0 \u00a0 \u00a0None of the above\t\u00a0\t\u00a0\tQuestion 9.9. (TCO 3) Which of the following statements would the extract the total value of all the orders?\u00a0\tAssume you have a table with the following columns:\t\u00a0 (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0SELECT Total(OrderTotal)\tFROM OrderTable;\t\u00a0 \u00a0 \u00a0 \u00a0SELECT Sum(OrderTotal)\tFROM OrderTable;\t\u00a0 \u00a0 \u00a0 \u00a0SELECT Sum(OrderTotal)\tFROM OrderTable\tGROUP BY OrderTotal;\t\u00a0 \u00a0 \u00a0 \u00a0SELECT Rollup(OrderTotal)\tFROM OrderTable;\u00a0\t\u00a0\t\u00a0\t\u00a0\tQuestion 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)\t\u00a0 \u00a0 \u00a0 \u00a0The first query will run slower than the second query.\t\u00a0 \u00a0 \u00a0 \u00a0The second query will run slower than the second query.\t\u00a0 \u00a0 \u00a0 \u00a0The queries will run at the same speed.\t\u00a0 \u00a0 \u00a0 \u00a0All of the above\u00a0\t\u00a0\t\u00a0\t\u00a0\tQuestion 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)\t\u00a0 \u00a0 \u00a0 \u00a0The first query will run slower than the second query.\t\u00a0 \u00a0 \u00a0 \u00a0The second query will run slower than the first query.\t\u00a0 \u00a0 \u00a0 \u00a0The queries will run at the same speed.\t\u00a0 \u00a0 \u00a0 \u00a0All of the above\t\u00a0\t\u00a0\tQuestion 12.12. (TCO 7) Which of the following file formats are used to import data into SSRS. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0CSV\t\u00a0 \u00a0 \u00a0 \u00a0PDF\t\u00a0 \u00a0 \u00a0 \u00a0SLN\t\u00a0 \u00a0 \u00a0 \u00a0docx\t\u00a0\t\u00a0\tQuestion 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)\t\u00a0 \u00a0 \u00a0 \u00a0zroles\t\u00a0 \u00a0 \u00a0 \u00a0Separation of duties\t\u00a0 \u00a0 \u00a0 \u00a0Securing forms and reports\t\u00a0 \u00a0 \u00a0 \u00a0Using views\t\u00a0\t\u00a0\tQuestion 14.14. (TCO 8) _____ is the process of creating ciphertext. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Passcoding\t\u00a0 \u00a0 \u00a0 \u00a0Digital Certificate\t\u00a0 \u00a0 \u00a0 \u00a0Symmetric\t\u00a0 \u00a0 \u00a0 \u00a0Encryption\t\u00a0\t\u00a0\tQuestion 15.15. (TCO 9) Which of the following reports requires the reader to look at data in both column and row format? (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Matrix\t\u00a0 \u00a0 \u00a0 \u00a0Exception\t\u00a0 \u00a0 \u00a0 \u00a0Tabular\t\u00a0 \u00a0 \u00a0 \u00a0None of the above\t\u00a0\t\u00a0\tQuestion 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)\t\u00a0 \u00a0 \u00a0 \u00a0gross\t\u00a0 \u00a0 \u00a0 \u00a0minor\t\u00a0 \u00a0 \u00a0 \u00a0major\t\u00a0 \u00a0 \u00a0 \u00a0None of the above\t\u00a0\t\u00a0\tQuestion 17.17. (TCO 9) Which date function will return the difference between two dates in the specified units? (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0DATEDIFFERENCE\t\u00a0 \u00a0 \u00a0 \u00a0DATEPART\t\u00a0 \u00a0 \u00a0 \u00a0DATEDIFF\t\u00a0 \u00a0 \u00a0 \u00a0DATEADD\u00a0\t\u00a0\t\u00a0\tQuestion 18.18. (TCO 10) Which of the following represent a popular report-writing tool that is not a Microsoft application? (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Access Reports\t\u00a0 \u00a0 \u00a0 \u00a0SSRS\t\u00a0 \u00a0 \u00a0 \u00a0SSMS\t\u00a0 \u00a0 \u00a0 \u00a0Crystal Reports\u00a0\t\u00a0\t\u00a0\tQuestion 19.19. (TCO 10) Which of the following is NOT one of the formats available for reports? (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0XML\t\u00a0 \u00a0 \u00a0 \u00a0HTML\t\u00a0 \u00a0 \u00a0 \u00a0PDF\t\u00a0 \u00a0 \u00a0 \u00a0XPDF\u00a0\t\u00a0\t\u00a0\tQuestion 20.20. (TCO 2) Which date function will return the difference between two dates in the specified units? (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0DATEDIFFERENCE\t\u00a0 \u00a0 \u00a0 \u00a0DATEPART\t\u00a0 \u00a0 \u00a0 \u00a0DATEDIFF\t\u00a0 \u00a0 \u00a0 \u00a0DATEADD\u00a0\t\u00a0\t\u00a0\t\u00a0\tQuestion 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)\t\u00a0 \u00a0 \u00a0 \u00a0Datepart\t\u00a0 \u00a0 \u00a0 \u00a0Datediff\t\u00a0 \u00a0 \u00a0 \u00a0Dateout\t\u00a0 \u00a0 \u00a0 \u00a0Dateyear\t\u00a0\t\u00a0\tQuestion 22.22. (TCO 2) Which of the following functions would you use to extract characters from the middle of a string. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Left()\t\u00a0 \u00a0 \u00a0 \u00a0Right()\t\u00a0 \u00a0 \u00a0 \u00a0Middle()\t\u00a0 \u00a0 \u00a0 \u00a0Substring()\t\u00a0\t\u00a0\tQuestion 23.23. (TCO 3) Which of the following aggregate functions can be used with any data type. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0MAX\t\u00a0 \u00a0 \u00a0 \u00a0SUM\t\u00a0 \u00a0 \u00a0 \u00a0COUNT\t\u00a0 \u00a0 \u00a0 \u00a0AVG\t\u00a0\t\u00a0\tQuestion 24.24. (TCO 5) When using the report server project wizard the most crucial step is _______. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0selecting your data source\t\u00a0 \u00a0 \u00a0 \u00a0naming your project\t\u00a0 \u00a0 \u00a0 \u00a0selecting the location to save your project\t\u00a0 \u00a0 \u00a0 \u00a0selecting the correct template\t\u00a0\t\u00a0\tQuestion 25.25. (TCO 5) SSRS uses all of the following types of extensions except ______. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0data processing\t\u00a0 \u00a0 \u00a0 \u00a0security\t\u00a0 \u00a0 \u00a0 \u00a0delivery\t\u00a0 \u00a0 \u00a0 \u00a0communication\t\u00a0\t\u00a0\tQuestion 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)\t\u00a0 \u00a0 \u00a0 \u00a02\t\u00a0 \u00a0 \u00a0 \u00a03\t\u00a0 \u00a0 \u00a0 \u00a04\t\u00a0 \u00a0 \u00a0 \u00a05\t\u00a0\t\u00a0\tQuestion 27.27. (TCO 5) You can use the ______ in Business Intelligence Development Studio to access the report items controls. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Design tab\t\u00a0 \u00a0 \u00a0 \u00a0Toolbox\t\u00a0 \u00a0 \u00a0 \u00a0Toolbar\t\u00a0 \u00a0 \u00a0 \u00a0Preview tab\t\u00a0\t\u00a0\tQuestion 28.28. (TCO 7) The chart control used in SSRS is licensed from ______ software. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Dundas\t\u00a0 \u00a0 \u00a0 \u00a0Adobe\t\u00a0 \u00a0 \u00a0 \u00a0Apple\t\u00a0 \u00a0 \u00a0 \u00a0Google\t\u00a0\t\u00a0\tQuestion 29.29. (TCO 7) ______ presents group data in a grid layout that’s capable of expanding both rows and columns. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Table\t\u00a0 \u00a0 \u00a0 \u00a0Matrix\t\u00a0 \u00a0 \u00a0 \u00a0List\t\u00a0 \u00a0 \u00a0 \u00a0Dropdown\t\u00a0\t\u00a0\tQuestion 30.30. (TCO 6) A ____ parameter are used during the processing of the query. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Multidimensional Expressions (MDX)\t\u00a0 \u00a0 \u00a0 \u00a0query\t\u00a0 \u00a0 \u00a0 \u00a0report\t\u00a0 \u00a0 \u00a0 \u00a0Multivalue parameters\t\u00a0\t\u00a0\tQuestion 31.31. (TCO 6) Which data source credentials option is considered an integrated security type. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Prompt for credentials\t\u00a0 \u00a0 \u00a0 \u00a0Windows authentication\t\u00a0 \u00a0 \u00a0 \u00a0Hard-code credentials\t\u00a0 \u00a0 \u00a0 \u00a0No credentials\t\u00a0\t\u00a0\tQuestion 32.32. (TCO 6) ______ data source is used to dynamically choose the data source at runtime. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0embedded\t\u00a0 \u00a0 \u00a0 \u00a0shared\t\u00a0 \u00a0 \u00a0 \u00a0unique\t\u00a0 \u00a0 \u00a0 \u00a0expression\t\u00a0\t\u00a0\tQuestion 33.33. (TCO 3) Which of the following aggregate functions would not ignore null values. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0Count\t\u00a0 \u00a0 \u00a0 \u00a0AVG\t\u00a0 \u00a0 \u00a0 \u00a0MAX\t\u00a0 \u00a0 \u00a0 \u00a0Sum\t\u00a0\t\u00a0\tQuestion 34.34. (TCO 3) Which of the following is not a valid aggregate function. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0DATEDIFFERENCE\t\u00a0 \u00a0 \u00a0 \u00a0COUNT\t\u00a0 \u00a0 \u00a0 \u00a0MAX\t\u00a0 \u00a0 \u00a0 \u00a0MIN\t\u00a0\t\u00a0\tQuestion 35.35. (TCO 5) For the report server to use an extension, it must be ______. (Points : 5)\t\u00a0 \u00a0 \u00a0 \u00a0configured\t\u00a0 \u00a0 \u00a0 \u00a0linked to the server\t\u00a0 \u00a0 \u00a0 \u00a0added to the report\t\u00a0 \u00a0 \u00a0 \u00a0installed\t\u00a0\t\u00a0\t36. (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\u00a0\t\u00a0\tPart 1: Write the complete SQL statement needed to return the rows that meet these requirements.\t\u00a0\tPart 2: What rows will be returned from this query? List the customer ID only of the rows to be returned.\t\u00a0\tPart 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)\tPart 3: To extract the three-digit exchange I used the LEFT(Phone,3) funcion.\u00a0\t\u00a0\t37. (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.\ttblCustomer:\t\u00a0\tPart 1:\u00a0\tSELECT City, COUNT(*) FROM tblCustomer\u00a0\tGROUP BY City HAVING COUNT(*)>1\u00a0\tORDER BY City DESC;\tPart 2: Did you select any filter clause(s)? (WHERE, HAVING) Justify your choice of filter(s). (Points : 25)\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t\u00a0\t38. (TCO 6) \u00a0Evaluate 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.\t\u00a0\t\u00a0\t\u00a0\t\u00a0\tPart 1: Describe at least two enhancements that would make this report more readable to the user.\u00a0\tPart 1: The two enhancements I would make would be:\t\u00a0\tPart 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)\tPart 2: If I had to include two features to add functionality to the report and improve its flexibility they would be:<\/p>\n","protected":false},"excerpt":{"rendered":"
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) \u00a0 \u00a0 \u00a0 \u00a0SELECT \u00a0 \u00a0 \u00a0 \u00a0FROM \u00a0 \u00a0 \u00a0 \u00a0WHERE \u00a0 \u00a0 \u00a0 Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-203121","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=203121"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203121\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=203121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=203121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=203121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}