NEED SQL HELP

1. (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 : 3)

Question 2. 2. (TCO 2) Which of the following functions would you use to extract characters from the middle of a string. (Points : 3)

Question 3. 3. (TCO 2) Which of the following functions would you use to extract the year from your records in the database? (Points : 3)

Question 4. 4. (TCO 3) Which of the following functions would you use in an SQL statement to tally the number of values. (Points : 3)

Question 5. 5. (TCO 3) Which of the following clauses filters groups. (Points : 3)

Question 6. 6. (TCO 3) Which of the following is not a valid aggregate function. (Points : 3)

Question 7. 7. (TCO 2) Which of the following date functions syntax is incorrect. (Points : 3)

Question 8. 8. (TCO 2) In the following SQL date function DatePart(yy, Birthdate); what does yy signify. (Points : 3)

Question 9. 9. (TCO 2) When using the Convert function, the _____ identifier signifies the format of the output. (Points : 3)

Question 10. 10. (TCO 3) Aggregate functions ignore the ______values. (Points : 3)