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

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)
Left()
Right()
Middle()
Substring()