Question $16(1$ point$)$

Which of the following statements is true?

Question $16$ options:

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

Every data type can be implicitly converted to every other data type.

Values are implicitly converted from the data type with higher precedence to the data type with lower precedence.

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

Question $17(1$ point$)$

Which choice below will increase the storage capacity of a varchar column so it can store up to $2$ gigabytes of data?

Question $17$ options:

varchar$($large$)$

varchar$($max$)$

varchar XTREME

varchar$($XL$)$

Question $18(1$ point$)$

To code a$/$an $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ value as a literal, precede the value with the character N

Question $18$ options:

ASCII

fixed$-$length string

Unicode

variable$-$length string

Question $19(1$ point$)$

Which data types are used to store whole numbers?

Question $19$ options:

integer

decimal

real data

string

Question $20(1$ point$)$

If ZipCode is a varchar column that contains the value $93702,$ what will the Solution column evaludate to$?$

ISNUMERIC$($ZipCode$)$ AS Solution

Question $20$ options:

true

false

null

none

Question $21(1$ point$)$

Which uses the least amount of storage?

Question $21$ options:

'example' stored in a column of type nchar$(20)$

'exam' stored in a column of type nchar$(20)$

$\text{'}$ex$\text{'}$ stored in a column of type nchar$(20)$

they all use the same amount of storage