Which Transact-SQL statement should you run?

You need to create a table named MiscellaneousPayment that meets the following requirements:

Which Transact-SQL statement should you run?

A)

B)

C)

D)

E)

F)

G)

A . Option A
B . Option B
C . Option C
D . Option D
E . Option E
F . Option F
G . Option G

View Answer

Answer: D

Explanation:

Incorrect Answers:

A: For column Reason we must use nvarchar, not varchar, as multilingual values must be supported. NEWSEQUENTIALID cannot be referenced in queries. In addition, the money datatype uses rounding and will result in rounding errors.

B: We cannot use INT for the Id column as new values must be automatically generated.

C: For column Reason we must use nvarchar, not varchar, as multilingual values must be supported.

E: NEWSEQUENTIALID cannot be referenced in queries.

F: The money datatype uses rounding and will result in rounding errors. We should use decimal instead.

Note: Nvarchar stores UNICODE data. If you have requirements to store UNICODE or multilingual data, nvarchar is the choice. Varchar stores ASCII data and should be your data type of choice for normal use.

References: https://docs.microsoft.com/en-us/sql/t-sql/data-types/nchar-and-nvarchar-transact-sql