Sqlserver Interview questions


Total available count: 45
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 different index configurations a table can have?
2
Which TCP/IP port does SQL Server run on? How can it be changed?
3
Explain Transact-SQL optimization tips?
4
What is Foreign key?
5
How can a programmer enforce to use particular Index?