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
1.( TCO 5) Which of the following is not an SSRS tool 2.( TCO 5) Reports created using report designer or report builder are generated in which of the following reporting languages. 3.( TCO 5) Which of the following tools is built on the Visual Studio 2008 shell 4.( TCO 5) Which of the following tools would you use to manage your SQL Server connection and reporting services? 5.( TCO 5) When using the report server project wizard the most crucial step is _______. 6.( TCO 5) SQL Server Reporting Services provides the following command line utility ____ to modify encrypted connections. 7.( TCO 5) When creating reports with Visual Studio, a report data set can contain an _______ or shared data source 8.( TCO 5) When creating the a report using Business Intelligence Development Studio, you can view the report using the ______ tab 9.( TCO 5) By default when we add a table to our report in Business Intelligence Development Studio, the table has _____ columns