Database Collation

Question 1

CI/CS

Answer 1

Case Insensitive/Sensitive

Question 2

AI/AS

Answer 2

Accent Insensitive/Sensitive

Question 3

SC

Answer 3

Supplementary Characters

Question 4

WS

Answer 4

Width Sensitive (Full width/Half Width characters)

Question 5

KS

Answer 5

Kana Sensitive

Question 6

BIN

Answer 6

Sorts and compares data in SQL Server tables based on the bit patterns defined for each character

Question 7

BIN2

Answer 7

Sorts and compares data in SQL Server tables based on Unicode code points for Unicode data

Question 8

VSS

Answer 8

Variation Selector Sensitive

Question 9

UTF8

Answer 9

Enables UTF-8 encoded data to be stored in SQL Server