SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

Can we add an identity column to decimal datatype?

1042

Why use sub query in sql server and list out types of sub queries?

1055

What is the native system stored procedure to execute a command against all databases?

1085

List out the differences between the clustered index and non-clustered index in sql server?

1050

What are the differences between union, intersect, and minus operators?

1139

Explain the properties of a relational table?

1075

Can we store videos inside the sql server table?

1027

How can you fetch alternate records from a table?

1013

What do you mean by table and field in sql?

1064

What are the differences between left join and inner join in sql server?

1152

What is the sql case statement used for?

1131

How sql server executes a statement with nested subqueries?

1090

What is the sql case statement used for? Explain with an example?

1039

Explain how to send email from sql database?

1106

What are the different authentication modes in sql server?

1167

Un-Answered Questions { SQL Server }

What is indexing explain it with an example?

1070

How you can get the list of largest tables in a database?

1062

What are the advantages of using stored procedures?

1004

What is the security principal at the database level that represents your session?

991

Name three of the features managed by the surface area configuration tool? : sql server security

1029

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1049

How many replicas are maintained for each sql azure db?

124

How to modify an existing stored procedure in ms sql server?

1137

What is the difference between set and select?

1159

What are commit and rollback in sql?

1170

What are page splits?

1050

Which command is used for user defined error messages?

1103

How to configure and test odbc dsn settings?

1224

What is a domain constraint give an example?

1109

Explain what are the basic functions for master, msdb, model, tempdb databases?

1028

For More Un-Answered { SQL Server } Questions Click Here