19 . ( TCO 10 ) Which of the following is NOT one of the formats available for reports ? ( Points : 5 ) XML HTML PDF XPDF
20 . ( 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 . ( Points : 5 ) CHAR VARCHAR Text String
21 . ( TCO 2 ) Which of the following functions would you use to extract the from your records in the database ? ( Points : 5 ) Datepart Datediff Dateout Dateyear
22 . ( TCO 2 ) Which of the following functions would return the current date based on the computer clock . ( Points : 5 ) TodayDate () PutDate () FindDate () GetDate ()
23 . ( TCO 3 ) Aggregate functions ignore the ______ values . ( Points : 5 ) character numeric date null