1. (TCO 1) Which of the following sets of SQL clauses represent the minimum combination of clauses to make a working SQL statement? (Points : 5)\tSELECT, WHERE\tFROM, WHERE\tSELECT, FROM\tFROM, ORDER BY\t\u00a0\t2. (TCO 1) Which of the following would be considered a logical operator? (Points : 5)\t=\t>=\tAND\tIS NULL\t\u00a0\t3. (TCO 1) Which of the following is true about ORDER BY clauses? (Points : 5)\tThe default order is ascending when none is specified.\tNumerical columns are sorted from highest to lowest where no sort order is specified.\tColumns on which sorting must be conducted cannot be identified by their position in their table.\tCharacter columns are evaluated from right to left.\t\u00a0\t4. (TCO 1) Which of the following would extract all rows containing the numbers 4 or 8? (Points : 5)\tWHERE number = 4 or number = 8\tWHERE number BETWEEN 4 and 8\tWHERE number = ‘4 or 8’\tWhere number = ‘4’ or ‘8’\t\u00a0\t5. (TCO 1) Assume you want to associate a TaxpayerTable with a PrincipalResidenceTable. The PrincipalResidentTable contains the address where each taxpayer lives. Assume that each taxpayer can have only one residence; however, more than one person at the address can be considered a taxpayer. What is the relationship between the TaxpayerTable and PrincipalResidenceTable? (Points : 5)\tMany-To-One\tOne-To-Many\tMany-to-Many\tOne-to-One\t\u00a0\t6. (TCO 1) Which of the following would display values from the city field in the Professor table, removing all duplicate city names? (Points : 5)\tSELECT City DISTINCT FROM Professor\tSELECT City FROM DISTINCT Professor\tSELECT DISTINCT City FROM Professor\tSELECT DISTINCT FROM Professor\t\u00a0\t7. (TCO 1) Assume you have a table called StudentTable. You would like to extract the lastname of all students who have not yet declared their major. Which of the following WHERE clauses would accomplish this? (Points : 5)\tWHERE major = ” ”\tWHERE major = ‘ ‘\tWHERE major IS NULL\tWHERE major = ‘NULL’\t\u00a0\t8. (TCO 3) Which of the following statements would count the number of customers within each state?\tAssume you have a table with the following columns:\t(Points : 5)\tSELECT State, Count(*)\tFROM CustomerTable\tGROUP BY State;\tSELECT CustomerID, Count(State)\tFROM CustomerTable\tGROUP BY CustomerID;\tSELECT State, Count(CustomerID)\tFROM CustomerTable;\tNone of the above.\t\u00a0\t\u00a0\t9. (TCO 3) Which of the following statements would the extract average income of the customers in each city? Assume you have a table with the following columns:\t(Points : 5)\tSELECT City, Avg(Income)\tFROM CustomerTable\tGROUP BY City;\tSELECT State, Avg(Income)\tFROM CustomerTable\tGROUP BY State;\tSELECT City, Average(Income)\tFROM CustomerTable\tGROUP BY City;\tSELECT State, Average(Income)\tFROM CustomerTable\tGROUP BY State;\t\u00a0\t\u00a0\t10. (TCO 4) Query ______ is the complete process from submission of a query to its actual execution. (Points : 5)\toptimization\tcompilation\tinsertion\tNone of the above\t\u00a0\t11. (TCO 4) Assume you have two queries that must extract all rows that have a value of greater than $100 in an Income column. You are considering two ways of writing your WHERE clause. The first option is to extract all columns that are NOT less than or equal to $100. The second option is to extract all columns that are greater than $100. Which option should you choose to ensure your query runs as quickly as possible? (Points : 5)\tThe first option\tThe second option\tIt doesn’t matter which option you pick; they will run the same no matter what.\tAll of the above\t\u00a0\t12. (TCO 7) Which of the file formats can be viewed using Adobe Acrobat Reader? (Points : 5)\tCSV\tPDF\tTIFF\tXLSX\t\u00a0\t\u00a0\t13. (TCO 8) Name the security concept involves ensuring that one person doesn’t have control over too many steps in a process. (Points : 5)\tzroles\tSeparation of duties\tSecuring forms and reports\tUsing views\t\u00a0\t14. (TCO 8) _____ encryption offers a more granular level of encryption. (Points : 5)\tRole based\tObject-based security\tColumn-level\tNone of the above\t\u00a0\t\u00a0\t15. (TCO 9) Which of the following reports requires the reader to read down columns to understand its meaning? (Points : 5)\tMatrix\tException\tTabular\tNone of the above\t\u00a0\t16. (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)\tgross\tminor\tmajor\tNone of the above\t\u00a0\t17. (TCO 9) Aggregation functions help grouping scenarios by providing _____________ for groups. (Points : 5)\ttotals\tsubtotals\ttitles\texpressions\t\u00a0\t18. (TCO 10) Which of the following represent a popular report-writing tool that is not a Microsoft application? (Points : 5)\tAccess Reports\tSSRS\tSSMS\tCrystal Reports\t\u00a0\t19. (TCO 10) Which of the following is NOT one of the formats available for reports? (Points : 5)\tXML\tHTML\tPDF\tXPDF\t\u00a0\t20. (TCO 2) Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations. (Points : 5)\tCHAR\tVARCHAR\tText\tString\t\u00a0\t21. (TCO 2) Which of the following functions would you use to extract the from your records in the database? (Points : 5)\tDatepart\tDatediff\tDateout\tDateyear\t\u00a0\t22. (TCO 2) Which of the following functions would return the current date based on the computer clock. (Points : 5)\tTodayDate()\tPutDate()\tFindDate()\tGetDate()\t\u00a0\t23. (TCO 3) Aggregate functions ignore the ______values. (Points : 5)\tcharacter\tnumeric\tdate\tnull\t\u00a0\t24. (TCO 5) For the report server to use an extension, it must be ______. (Points : 5)\tconfigured\tlinked to the server\tadded to the report\tinstalled\t\u00a0\t25. (TCO 5) The easiest and fastest way to create a report is to use the _____ tool. (Points : 5)\treport builder\treport wizard\treport template\treport manager\t\u00a0\t26. (TCO 5) When creating the a report using Business Intelligence Development Studio, you can view the report using the ______tab. (Points : 5)\tToolbox\tDesign\tOutput box\tPreview\t\u00a0\t27. (TCO 5) The data set contains all of the following except ______. (Points : 5)\treuslts of the query\tSQL statement\tpointer to the data source\tname of data source\t\u00a0\t28. (TCO 7) The chart _____ contains the plotting area of a chart. (Points : 5)\tcategory\tdata\tseries\tareas\t\u00a0\t29. (TCO 7) _____ presents a grid layout with static columns and expands detail data data row by row. (Points : 5)\tTable\tMatrix\tList\tDropdown\t\u00a0\t30. (TCO 6) _____ regions are items that must be associated with a data set. (Points : 5)\tProcessor\tReport\tPresentation\tData\t\u00a0\t31. (TCO 6) Which of the data source credential options is the least recommended because of security risks. (Points : 5)\tHard-code\tPrompt\tWindows Authentication\tNo Credentials\t\u00a0\t32. (TCO 6) Which of the following is not a type of data source in SSRS. (Points : 5)\tembedded\tshared\tcalculated\texpression\t\u00a0\t33. (TCO 3) Which of the following functions would you use in an SQL statement to tally the number of values. (Points : 5)\tMax()\tAvg()\tSum()\tCount()\t\u00a0\t34. (TCO 3)________functions are SQL mathematical summaries. (Points : 5)\tSummation\tSummary\tAggregate\tCummalative\t\u00a0\t35. (TCO 5) When using the report server project wizard the most crucial step is _______. (Points : 5)\tselecting your data source\tnaming your project\tselecting the location to save your project\tselecting the correct template\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 customers in the list. Order the rows in alphabetical order of city. Be sure to give the calculated columns an alias.\t\u00a0\ttblCustomer:\t\u00a0\tCustID (PK)\t\u00a0\tLastNameFirstNamePhoneCityRegionOverdue Status*PreferredIncomeNumOrdersBalanceBirthdate\t10\t\u00a0\tSmithBob123-4567OrlandoNorth\tPaid\t\u00a0\tY1000051001\/1\/1978\t12RamirezJose422-1234ApexSouthPaidY50000166002\/8\/1970\t13WashingtonTerrell951-1234SujourEast[null]Y20000257003\/5\/1985\t15JonesBill963-7894AxeCrossingWestUnpaidY16900250012\/1\/1990\t17MoralesSandy951-1234OrlandoNorthPaidN85000904008\/3\/1986\t21PrincipeMichelle963-4561ApexSouthPaidN94000853007\/2\/1974\t23MavisJohn147-4561SujourEastUnpaidY25000266003\/5\/1989\t*Overdue Status indicates customers with a balance that is 30 or more days overdue\t\u00a0\t\u00a0\t\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)\t\u00a0\t\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\tCustID (PK)\t\u00a0\tLastNameFirstNamePhoneCityRegionOverdue Status*PreferredIncomeNumOrdersBalanceBirthdate\t10\t\u00a0\tSmithBob123-4567OrlandoNorth\tPaid\t\u00a0\tY1000051001\/1\/1978\t12RamirezJose422-1234ApexSouthPaidY50000166002\/8\/1970\t13WashingtonTerrell951-1234SujourEast[null]Y20000257003\/5\/1985\t15JonesBill963-7894AxeCrossingWestUnpaidY16900250012\/1\/1990\t17MoralesSandy951-1234OrlandoNorthPaidN85000904008\/3\/1986\t21PrincipeMichelle963-4561ApexSouthPaidN94000853007\/2\/1974\t23MavisJohn147-4561SujourEastUnpaidY25000266003\/5\/1989\t*Overdue Status indicates customers with a balance that is 30 or more days overdue\t\u00a0\t\u00a0\tPart 1: Build your SELECT statement by choosing the certain clauses from the list below and putting the clauses in the correct order:\tSELECT City, Count(*)\tORDER BY 2\tWHERE Count(*) > 1\tSELECT Region, Count(*)\tGROUP BY City\tFROM tblCustomer\tORDER BY Count(*)\tHAVING Count(*) > 1\tGROUP BY Region\tORDER BY 2 DESC\t\u00a0\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\t38. (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.\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.\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)<\/p>\n","protected":false},"excerpt":{"rendered":"
1. (TCO 1) Which of the following sets of SQL clauses represent the minimum combination of clauses to make a working SQL statement? (Points : 5) SELECT, WHERE FROM, WHERE SELECT, FROM FROM, ORDER BY \u00a0 2. (TCO 1) Which 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-203126","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203126","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=203126"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203126\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=203126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=203126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=203126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}