IndiaBIX

Interview Questions - SQL Server Common Questions

Why should I learn to solve SQL Server Common Questions technical interview questions?

Learn and practise solving SQL Server Common Questions technical interview questions and answers to enhance your skills for clearing technical interviews, HR interviews, campus interviews, and placement tests.

Where can I get technical SQL Server Common Questions technical interview questions and answers with explanations?

IndiaBIX provides you with lots of fully solved SQL Server Common Questions technical interview questions and answers with a short answer description. You can download SQL Server Common Questions technical interview questions and answers as PDF files or e-books.

How do I answer SQL Server Common Questions technical interview questions from various companies?

You can answer all kinds of SQL Server Common Questions technical interview questions by practising the given exercises (short answer type). You can also find the frequently asked SQL Server Common Questions technical interview questions with answers from various companies, such as TCS, Wipro, Infosys, CTS, IBM, etc.

1.
Which TCP/IP port does SQL Server run on? How can it be changed?
SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.
2.
What are the difference between clustered and a non-clustered index?
  1. A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.
  2. A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
3.
What are the different index configurations a table can have?
A table can have one of the following index configurations:
  1. No indexes
  2. A clustered index
  3. A clustered index and many nonclustered indexes
  4. A nonclustered index
  5. Many nonclustered indexes
4.
What are different types of Collation Sensitivity?
  1. Case sensitivity - A and a, B and b, etc.
  2. Accent sensitivity
  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.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers