BIS 345 MENTOR Keep Learning /bis345mentor.com BIS 345 MENTOR Keep Learning /bis345mentor.com | Page 5
None of the above
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
17. (TCO 9) Aggregation functions help grouping scenarios by
providing _____________ for groups. (Points : 5)
totals
subtotals
titles
expressions
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
19. (TCO 10) Which of the following is NOT one of the formats
available for reports? (Points : 5)
XML
HTML
PDF
XPDF
20. (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)
CHAR
VARCHAR
Text