BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 9

34. (TCO 3)________functions are SQL mathematical
summaries. (Points : 5)
Summation
Summary
Aggregate
Cummalative
35. (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
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
customers in the list. Order the rows in alphabetical order of city.
Be sure to give the calculated columns an alias.
tblCustomer:
CustID (PK)
LastNameFirstNamePhoneCityRegionOverdue
Status*PreferredIncomeNumOrdersBalanceBirthdate
10
SmithBob123-4567OrlandoNorth
Paid
Y1000051001/1/1978
12RamirezJose422-1234ApexSouthPaidY50000166002/8/1970