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?

1055

What are the different index configurations a table can have?

1008

Explain difference between cross join and full outer join?

1064

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

1224

Explain what is use of dbcc commands?

1131

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

1087

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

1006

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

984

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

1028

Explain what are commit and rollback in sql?

981

please differentiate between delete and truncate?

1038

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

1086

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?

1092

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

1054

Explain what is scheduled job and how to create it?

1012

Un-Answered Questions { SQL Server }

What is sqlservr.exe - process - sql server (sqlex?press)?

1152

When a primary key constraint is included in a table, what other constraints does this imply?

1018

What is the purpose of sql profiler in sql server?

1066

How to get @@error and @@rowcount at the same time?

1083

Explain filtered indexes?

1040

What are statistics?

1050

How do you improve the performance of a SQL Azure Database?

137

What are the new features of sql server 2012 reporting service?

141

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

1088

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1144

Explain error and transaction handling in sql server?

1062

Explain the etl (extraction, transformation, and loading)?

1049

What is a data collection table?

1051

Is it possible to call a stored procedure within a stored procedure?

1026

Is null vs coalesce?

927

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