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

What are the different types of replication you can set up in sql server?

1088

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

961

What information is maintained within the msdb database?

1018

Can a table be moved to different filegroup?

1025

Which database stores information about replication?

1126

Can the “if update (colname)” statement be used in a delete trigger?

1034

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

941

What is the difference between dbcc indexdefrag and dbcc reindex?

1035

How many types of stored procedures are there in sql server?

1057

What is the purpose of linked server configuration in sql server?

1094

In how many ways you can invoke ssrs reports?

147

Introduction of rollup clause using sum and group by clause?

1011

What is primary key, unique key, and foreign key?

1015

What is a trigger in sql server?

1227

What are differences in between sql server 2012 and sql server 2016?

1097

Un-Answered Questions { SQL Server }

How to convert binary strings into integers in ms sql server?

1079

How to replace null values in expressions using isnull()?

1152

Explain log shipping?

1076

What is merge?

1069

How to set database to be single_user in ms sql server?

1080

What is acid db?

931

What is the use of stored procedure?

980

What is a covering index?

1042

How do I make a resultset scrollable?

1012

What is ms sql server service broker?

1041

What are differences in between sql server 2012 and sql server 2016?

1097

What is indexing and its types?

1056

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1095

How will you optimize a stored procedure optimization?

1115

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

1076

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