Which uses the least amount of storage?

Question $11$ options:

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

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

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

they all use the same amount of storage

Question $12(1$ point$)$

Which statements are true about the ROUND function?

Question $12$ options:

It returns the number rounded to the specified precision

If the length is positive, the digits to the left of the decimal point are rounded

To truncate the function rather than round it$,$ code a zero value for the function

all of the above

Question $13(1$ point$)$

The varchar and nvarchar data types to store variable$-$length strings. Which of the statements below is true?

Question $13$ options:

Data stored using these data types occupies only the number of bytes needed to store the string

They are typically used to define columns with a fixed number of characters.

In general, they are less efficient than fixed$-$length strings.

all of the above

Question $14(1$ point$)$

The char and nchar data types are used to store fixed$-$length strings. Which of the statements below is true?

Question $14$ options:

Data stored using these data types occupies the same number of bytes regardless of the actual length of the string.

They are typically used to define columns that have a fixed number of characters

The char$(2)$ data type will always contain two characters

all of the above

Question $15(1$ point$)$

If you assign a value with one data type to a column with another data type, SQL Server converts the value to the data type of the column using what?

Question $15$ options:

explicit conversion

implicit conversion

Unicode values

scientific notation