BIS 345 Data Analysis for Decision Making w/lab Week 2 Quiz Answers – Homeworkmade

DOWNLOAD: BIS 345 Data Analysis for Decision Making w/lab Week 2 Quiz Answers – Homeworkmade

BIS 345 Week 2 Quiz

1. (TCO 2) Which of the following functions would you use to convert data from one type to another.
2. (TCO 2) Which of the following functions would you use to extract characters from the middle of a string.
3. (TCO 2) Which of the following functions would you use to extract the year from your records in the database?
4. (TCO 3) Which of the following functions would you use in an SQL statement to tally the number of values.
5. (TCO 3) Which of the following clauses filters groups.
6. (TCO 3) Which of the following is not a valid aggregate function.
7. (TCO 2) Which of the following date functions requires a timestamp parameter when use.
8. (TCO 2) In the following SQL date function DatePart(yy, Birthdate); what does yy signify.
9. (TCO 2) The DateDiff function requires how many parameters.
10. (TCO 3) Aggregate functions ignore the ______values.