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 you explain what are commit and rollback in sql?

986

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1053

Do you know what are pages and extents? : SQL Server Architecture

1038

Explain the truncate command? : SQL Server Architecture

1232

What are page splits? : SQL Server Architecture

1037

What is tempdb database? : SQL Server Architecture

1256

What is database architecture? : SQL Server Architecture

1099

What are different types of raid configurations? : SQL Server Architecture

1133

What do you know about system database? : SQL Server Architecture

1036

What are the database objects? : SQL Server Architecture

1098

What are the restrictions applicable while creating views? : SQL Server Architecture

1083

Explain the microsoft sql server delete command? : SQL Server Architecture

1146

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1099

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

1051

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1059

Un-Answered Questions { SQL Server }

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1123

What is public role in sql server?

1211

How self join is different from outer join?

1176

what data regions are and what are the different data regions?

146

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1014

How can you find out how many rows returned in a cursor?

1085

What are distinctive joins find as a part of sql?

1000

How to create a dml trigger using create trigger statements?

1084

Which are new data types introduced in sql server 2008?

1104

What do you understand by hotfixes and patches in sql server?

1030

Explain the dbcc pintable command when would you use it?

968

How can we rewrite sub-queries into simple select statements or with joins?

1027

What are the steps you can take to avoid “deadlocks”?

1024

What is the sql server agent?

1145

What is dbcc command in sql server?

1149

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