Ch. 8 questions – Flashcards
Unlock all answers in this set
Unlock answersquestion
The difference between the CAST function and the CONVERT function is that the ______________________________ function accepts an optional style argument that lets you specify a format for the result.
answer
CONVERT
question
All of the following values can be stored in a column that's defined as decimal(6,2), except
answer
32492.05
question
Which uses the least amount of storage?
answer
they all use the same amount of storage
question
Which uses the least amount of storage?
answer
'ex' stored in a column of type varchar(20)
question
The date/time data types can store
answer
all of the above
question
Which of the following statements is true about the CONVERT and TRY_CONVERT functions?
answer
CONVERT returns an error if the expression can't be converted, but TRY_CONVERT returns a NULL value.
question
The ____________________ data types are used to store whole numbers.
answer
integer
question
The _____________________ of a decimal value indicates the total number of digits that can be stored in a decimal data type.
answer
precision
question
To store a date value without storing a time value, you can use the
answer
date data type
question
Which of the following statements is true?
answer
Implicit data type conversion is performed any time you mix values of different data types in an expression.
