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?

1087

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

959

What information is maintained within the msdb database?

1016

Can a table be moved to different filegroup?

1024

Which database stores information about replication?

1123

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

1032

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

937

What is the difference between dbcc indexdefrag and dbcc reindex?

1031

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

1055

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

1089

In how many ways you can invoke ssrs reports?

147

Introduction of rollup clause using sum and group by clause?

1009

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

1012

What is a trigger in sql server?

1225

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

1090

Un-Answered Questions { SQL Server }

Difference between DELETE and TRUNCATE?

1094

What is the difference between Normalization and De-normalization?

1139

What do you understand by recursive stored procedures?

1041

What is cross join in sql server joins?

1195

What is a mutating table error and how can you get around it?

1124

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1123

can an order by clause be used in a creation of a view?

1234

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

123

What is the use of set nocount on/off statement?

1138

How do you migrate data from mssql server to azure?

167

Explain isolation levels that sql server supports?

1081

What is row_number function?

1058

What is a partition function in sql server?

1212

How to get the number of affected rows?

1053

What are the encryption mechanisms in sql server?

1077

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