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?

1052

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

914

What information is maintained within the msdb database?

982

Can a table be moved to different filegroup?

976

Which database stores information about replication?

1071

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

991

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

888

What is the difference between dbcc indexdefrag and dbcc reindex?

987

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

1016

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

1048

In how many ways you can invoke ssrs reports?

139

Introduction of rollup clause using sum and group by clause?

968

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

976

What is a trigger in sql server?

1176

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

1050

Un-Answered Questions { SQL Server }

What is data mart? : sql server analysis services, ssas

1056

Mention the differences between sql server and mysql.

1016

What are the methods used to protect against sql injection attack?

1068

What is policy management?

997

What is the difference between a function and a stored procedure?

1072

what stored procedure can you use to display the current processes? : Sql server administration

1010

How many types of subqueries are there in sql server?

992

Explain index in sql server?

1015

Can select statements be used on views in ms sql server?

1065

Where are sql server usernames and passwords stored in the sql server?

1116

What is precedence constraint?

983

Mention the 3 ways to get a count of the number of records in a table.

978

Delete duplicate rows without using rowid.

1533

Explain primary key, foreign key and unique key?

994

How to change the system date and time from SQL Plus Terminal ?

1221

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