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 2. (TCO 2) Which of the following functions would you use to extract characters from the middle of a string. 3. (TCO 2) Which date function will return the difference between two dates in the specified units? 4. (TCO 3) If you wanted to know the highest credit line in your customer database, which if the following functions would you use in your SQL. 5. (TCO 3) Which of the following clauses filters groups 6. (TCO 3) Which of the following characters can be used with the COUNT function to return the total numbers of rows in the query 7. (TCO 2) Which of the following date functions requires a timestamp parameter when use. 8. (TCO 2) Of the following which one properly displays the correct syntax for using a date in an SQL statement. 9. (TCO 2) When using the Convert function, the _____ identifier signifies the format of the output. 10. (TCO 3) The ______clause can be used to count values once and ignore repeated occurrences
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer