You can use what data type to store a date that includes a time zone offset?

Question $5$ options:

time

smalldatetime

datetime

datetimeoffset

Question $6(1$ point$)$

If FirstName contains $$Edward$$ and LastName contains $$Williams$,$ what will the Solution column contain when this code is executed?

LOWER$($LEFT$($FirstName$,1)+$ LEFT$($LastName$,7))$ AS Solution

Question $6$ options:

EWilliams

EWilliam

ewilliams

ewilliam

Question $7(1$ point$)$

Which function returns the string with any leading spaces removed?

Question $7$ options:

LTRIM

RTRIM

REPLACE

LEFT

Question $8(1$ point$)$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ characters can be used to encode most of the characters in most of the languages of the world.

Question $8$ options:

ASCII

fixed$-$length string

Unicode

variable$-$length string

Question $9(1$ point$)$

All of the following values can be stored in a column that$$s defined as decimal$(6,2),$ except

Question $9$ options:

$-246\mathrm{.}29$

$0$

$2479\mathrm{.}95$

$32492\mathrm{.}05$

Question $10(1$ point$)$

Write the code for casting a decimal field named InvoiceAmount to a varchar datatype using the CAST function

Question $10$ options:

CAST $($varcharDate$,$ InvoiceAmount$)$ AS varchar

CAST $($InvoiceAmount AS varchar$)$

CAST $($varcharDate$,$ InvoiceAmount, $107\mathrm{.}25)$ as varchar

CAST $($InvoiceAmount $=$ varchar$)$