Which code segment should you add at line 03?

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?

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,



Leave a Reply 0

Your email address will not be published. Required fields are marked *