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,
Answer D should bi CI_AI because it should be case insensitive, accent insensitive.
Should be UserName nvarchar(200) COLLATE Latin1_General_CI_AI NOT NULL
Answer D is close:)