Sqlserver interview questions


Total available count: 38
Subject - Databases
Subsubject - Sqlserver

What are different types of Collation Sensitivity?

There are four types of Collation Sensitivity available in SQL Server, They are as follows,
 
1. Case sensitivity:  A and a, B and b, etc.
2. Accent sensitivity:  Handling different types of accents as per business need.
3. Kana Sensitivity:  When Japanese kana characters Hiragana and Katakana are treated differently, it is called Kana sensitive.
4. Width sensitivity:  A single-byte character (half-width) and the same character represented as a double-byte character (full-width) are treated differently than it is width sensitive.



Next 5 interview question(s)

1
What are the authentication modes in SQL Server?
2
What are the data types in SQL Server?
3
What are the difference between clustered and a non-clustered index?
4
What are the differences between UNION and JOINS in SQL Server?
5
What are the different index configurations a table can have?


Comments