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

Do you know what is lock escalation?

1058

What are the different index configurations a table can have?

1013

Explain difference between cross join and full outer join?

1068

What is the stuff and how does it differ from the replace function?

1229

Explain what is use of dbcc commands?

1143

Explain what is raid and what are different types of raid levels?

1094

Explain the use of keyword with encryption. Create a store procedure with encryption?

1010

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

990

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

1031

Explain what are commit and rollback in sql?

982

please differentiate between delete and truncate?

1041

Do you know data definition language, data control language and data manipulation language?

1091

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?

1101

How to search for a string in all stored procedure in sql server?

1061

Explain what is scheduled job and how to create it?

1026

Un-Answered Questions { SQL Server }

How to create a trigger for insert only?

1089

What are the instances when triggers are appropriate?

1022

How to provide default values to function parameters?

1225

What is sql injection and why is it a problem? : sql server security

1192

How to throw custom exception in Stored Procedure?

1097

What is intellisense?

1105

What are the differences between lost updates and uncommitted dependencies?

1147

What is filtered index?

1145

State the difference between local and global temporary tables?

1175

What are the components of dbms?

999

How to end a stored procedure properly in ms sql server?

1149

How to automatically create a log when an exception is being received into SQL Server?

1362

Can a table be moved to different filegroup?

1029

Explain the creation and execution of a user-defined function in the sql server?

1113

Can primary key be null?

986

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