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

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:
--------------------------------------------------------------------
BIS 345 Quiz 1
FOR MORE CLASSES VISIT
www.bis345mentor.com
1. (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
2. (TCO 2) Which of the following functions would you use to extract
characters from the middle of a string.
3. (TCO 2) Which date function will return the difference between two dates
in the specified units?
4. (TCO 3) If you wanted to know the highest credit line in your customer
database, which if the following functions would you use in your SQL.
5. (TCO 3) Which of the following clauses filters groups
6. (TCO 3) Which of the following characters can be used with the COUNT
function to return the total numbers of rows in the query
7. (TCO 2) Which of the following date functions requires a timestamp
parameter when use.
8. (TCO 2) Of the following which one properly displays the correct syntax
for using a date in an SQL statement.
9. (TCO 2) When using the Convert function, the _____ identifier signifies
the format of the output.
10. (TCO 3) The ______clause can be used to count values once and
ignore repeated occurrences
--------------------------------------------------------------------
BIS 345 Quiz 2
FOR MORE CLASSES VISIT
www.bis345mentor.com