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 =========================================================