SQL Server Interview Questions and Answers

SQL Server Interview Questions and Answers

Top SQL Server Interview Questions and Answers: Below, we have covered detailed answers to the SQL Server Interview Questions Which will be helpful to freshers and experienced Professionals. All the best for your interview Preparation.

Which TCP/IP port does SQL Server run on? How can it be changed?

What are the difference between clustered and a non-clustered index?

What are the different index configurations a table can have?

What are different types of Collation Sensitivity?

What is OLTP (Online Transaction Processing)?

What's the difference between a primary key and a unique key?

What is difference between DELETE and TRUNCATE commands?

When is the use of UPDATE_STATISTICS command?

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

What are the properties and different Types of Sub-Queries?

What is SQL Profiler?

What are the authentication modes in SQL Server? How can it be changed?

Which command using Query Analyzer will give you the version of SQL server and operating system?

What is SQL Server Agent?

Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

What is Log Shipping?

Name 3 ways to get an accurate count of the number of records in a table?

What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

What is the difference between a Local and a Global temporary table?

What is the STUFF function and how does it differ from the REPLACE function?


What is UNIQUE KEY constraint?


What is CHECK Constraint?

What is NOT NULL Constraint?

How to get @@ERROR and @@ROWCOUNT at the same time?

What is a Scheduled Jobs or What is a Scheduled Tasks?

What are the advantages of using Stored Procedures?

What is a table called, if it has neither Cluster nor Non-Cluster Index? What is it used for?

Can SQL Servers linked to other servers like Oracle?

What is BCP? When does it used?

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

What is an execution plan? When would you use it? How would you view the execution plan?