70-433 · Question #57
You plan to add a new column named SmallKey to the Sales.Product table that will be used in a unique constraint. You are required to ensure that the following information is applied when adding the…
The correct answer is D. SQL_Latin1_General_CP1_CS_AS. SQL Server Collation Name consists of several parts, one of them is responsible for CaseSensitivity - CI specifies case-insensitive, CS specifies case-sensitive. BIN specifies the binary sort order to be used. So, because we want case-sensitive location, B and C are not…
Question
You plan to add a new column named SmallKey to the Sales.Product table that will be used in a unique constraint. You are required to ensure that the following information is applied when adding the new column:
'a1' and 'A1' are treated as different values 'a' and 'A' sort before 'b' and 'B' in an ORDER BY clause You need to select the collation that meets the requirements for the new column. Which collation should you select?
Options
- ALatin1_General_BIN
- BSQL_Latin1_General_CP1_CI_AI
- CSQL_Latin1_General_CP1_CI_AS
- DSQL_Latin1_General_CP1_CS_AS
How the community answered
(39 responses)- A3% (1)
- B8% (3)
- C18% (7)
- D72% (28)
Explanation
SQL Server Collation Name consists of several parts, one of them is responsible for CaseSensitivity - CI specifies case-insensitive, CS specifies case-sensitive. BIN specifies the binary sort order to be used. So, because we want case-sensitive location, B and C are not suitable. Latin1_General_BIN use binary sort order, but we want linguistical sort order (according to rules of language), not based on the code point values of characters.
Topics
Community Discussion
No community discussion yet for this question.