Chapter 8

d. they all use the same amount of storage

Which uses the least amount of storage? a. 'example' stored in a column of type nchar(20) b. 'exam' stored in a column of type nchar(20) c. 'ex' stored in a column of type nchar(20) d. they all use the same amount of storage

c. 'ex' stored in a column of type varchar(20)

Which uses the least amount of storage? a. 'example' stored in a column of type varchar(20) b. 'exam' stored in a column of type varchar(20) c. 'ex' stored in a column of type varchar(20) d. they all use the same amount of storage

d. 32492.05

All of the following values can be stored in a column that's defined as decimal(6,2), except a. -246.29 b. 0 c. 2479.95 d. 32492.05

a. Implicit data type conversion is performed any time you mix values of different data types in an expression.

Which of the following statements is true? a. Implicit data type conversion is performed any time you mix values of different data types in an expression. b. Every data type can be implicitly converted to every other data type. c. Values are implicitly converted from the data type with higher precedence to the data type with lower precedence. d. You can convert a data type implicitly by using either the CAST or the CONVERT function.

FALSE

TRUE OR FALSE: Every data type can be implicitly converted to every other data type.

TRUE

TRUE OR FALSE: Implicit data type conversion is performed any time you mix values of different data types in an expression.

FALSE

TRUE OR FALSE: You can convert a data type implicitly by using either the CAST or the CONVERT function.

INT

The _________ data types are used to store whole numbers.

CHAR

The ___________ function is typically used to insert control characters into a character string.

PRECISION

The ______________ of a decimal value indicates the total number of digits that can be stored in a decimal data type.

d. all of the above

The date/time data types can store __________. a. dates only b. dates and times c. times only d. all of the above

CONVERT

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.

date data type

To store a date value without storing a time value, you can use the __________.

DATETIMEOFFSET(N)

You can use the ______________ data type to store a date that includes a time zone offset.

UNICODE

________ characters can be used to encode the characters that are used in languages throughout the world.