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_CI_AI NOT NULL,
B. UserName varchar(200) COLLATE Latin1_GeneraI_CI_AI NOT NULL,
C. UserName nvarchar(200) COLLATE Latin1_General_CS_AS NOT NULL,
D. UserName varchar(200) COLLATE Latin1_General_CS_AS NOT NULL,
E. UserName nvarchar(200) COLLATE Latin1_General_CI_AS NOT NULL,
F. UserName varchar(200) COLLATE Latin1_General_CI_AS NOT NULL,
Correct Answer: A
Explanation/Reference:
A lot of the questions had a minor change that you need to pay attention to. Otherwise if you simply remember the answer, you will get it wrong.
example 1. a question that had the table column specifications of "english" would normally result in the answer being "varchar", but the question now changed to "international", so you need to know that the answer is "nvarchar".
example 2. "case sensitive, accent sensitive" would usually be "CS_AS", but now the question changed to "case insensitive, accent sensitive" so its "CI_AS".
So while to the untrained eye, the questions appear the same. They are only 99% the same, but the specifications may have changed slightly. So pay attention.
According to these references, the answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms184391.aspx
http://msdn.microsoft.com/en-us/library/ms143726.aspx
http://msdn.microsoft.com/en-us/library/ff848763.aspx