Details of this Paper

NEED SQL HELP

Description

solution


Question

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);CHAR;VARCHAR;Text;String;Question 2. 2. (TCO 2) Which of the following functions would you use to extract characters from the middle of a string. (Points: 3);Left();Right();Middle();Substring();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);Datepart;Datediff;Dateout;Dateyear;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);Max();Avg();Sum();Count();Question 5. 5. (TCO 3) Which of the following clauses filters groups. (Points: 3);Where;Order;Having;Group;Question 6. 6. (TCO 3) Which of the following is not a valid aggregate function. (Points: 3);DATEDIFFERENCE;COUNT;MAX;MIN;Question 7. 7. (TCO 2) Which of the following date functions syntax is incorrect. (Points: 3);Year(date_value);Month(date_value);Week(date_value);Day(date_value);Question 8. 8. (TCO 2) In the following SQL date function DatePart(yy, Birthdate), what does yy signify. (Points: 3);Data type;Time stamp;Data format;Data function;Question 9. 9. (TCO 2) When using the Convert function, the _____ identifier signifies the format of the output. (Points: 3);look;type;style;appearance;Question 10. 10. (TCO 3) Aggregate functions ignore the ______values. (Points: 3);character;numeric;date;null

 

Paper#69596 | Written in 18-Jul-2015

Price : $22
SiteLock