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.
UserNamenvarchar(200) COLLATE Latin1_General_CS_AS NOT NULL,
B.
UserNamevarchar(200) COLLATE Latin1_General_CS_AS NOT NULL,
C.
UserNamevarchar(200) COLLATE Latin 1_General_CS_AS NOT NULL,
D.
UserNamenvarchar(200) COLLATE Latin1_General_CI_AS NOT NULL,
D:
UserName nvarchar(200) COLLATE Latin1_General_CI_AI NOT NULL,
agree with your ans
agree sduku!
As Sduku mentioned, it should be CI_AI. (None of the answer provided is actually correct in the question is actually correct.)
None of the options is correct. According to the question it should be case-insensitive (CI) and accent-insensitive (AI) e.g. Latin1_General_CI_AI.
D is closest among the given options.
Possibly that either B or C should show collation with CI, which would make that one correct.