Home
Blog
NEED SQL HELP

NEED SQL HELP

Daniel Kevins

0 comments

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)

      [removed] CHAR
      [removed] VARCHAR
      [removed] Text
      [removed] 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)

      [removed] Left()
      [removed] Right()
      [removed] Middle()
      [removed] 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)

      [removed] Datepart
      [removed] Datediff
      [removed] Dateout
      [removed] 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)

      [removed] Max()
      [removed] Avg()
      [removed] Sum()
      [removed] Count()

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

      [removed] Where
      [removed] Order
      [removed] Having
      [removed] Group

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

      [removed] DATEDIFFERENCE
      [removed] COUNT
      [removed] MAX
      [removed] MIN

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

      [removed] Year(date_value)
      [removed] Month(date_value)
      [removed] Week(date_value)
      [removed] Day(date_value)

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

      [removed] Data type
      [removed] Time stamp
      [removed] Data format
      [removed] Data function

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

      [removed] look
      [removed] type
      [removed] style
      [removed] appearance

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

      [removed] character
      [removed] numeric
      [removed] date
      [removed] null

About the Author

Daniel Kevins

Follow me