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 )