BIS 345 MENTOR Keep Learning /bis345mentor.com BIS 345 MENTOR Keep Learning /bis345mentor.com | Page 15

gross minor major None of the above Question 17.17. (TCO 9) Which date function will return the difference between two dates in the specified units? (Points : 5) DATEDIFFERENCE DATEPART DATEDIFF DATEADD Question 18.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 Question 19.19. (TCO 10) Which of the following is NOT one of the formats available for reports? (Points : 5) XML HTML PDF XPDF Question 20.20. (TCO 2) Which date function will return the difference between two dates in the specified units? (Points : 5) DATEDIFFERENCE DATEPART DATEDIFF DATEADD Question 21.21. (TCO 2) Which of the following functions would you use to extract the year, month, or day records in the database? (Points : 5) Datepart Datediff Dateout Dateyear Question 22.22. (TCO 2) Which of the following functions would you use to extract characters from the middle of a string. (Points : 5)