You use SQL Server 2012 to maintain the data used by the applications at your company.
You plan to create a table named Table1 by using the following statement. (Line numbers are included for
reference only.)
You need to ensure that Table1 contains a column named UserName. The UserName column will:
Store string values in any language.
Accept a maximum of 200 characters.
Be case-insensitive and accent-insensitive.
Which code segment should you add at line 03?
A.
UserName nvarchar(200) COLLATE Latin1_General_CS_AS NOT NULL,
B.
UserName varchar(200) COLLATE Latin1_General_CI_AI NOT NULL,
C.
UserName varchar(200) COLLATE Latin 1_General_CS_AS NOT NULL,
D.
UserName nvarchar(200) COLLATE Latin1_General_CI_AI NOT NULL,