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)