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?

1018

What are the different index configurations a table can have?

969

Explain difference between cross join and full outer join?

1014

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

1141

Explain what is use of dbcc commands?

1064

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

1030

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

967

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

947

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

987

Explain what are commit and rollback in sql?

940

please differentiate between delete and truncate?

999

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

1045

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?

1055

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

1008

Explain what is scheduled job and how to create it?

965

Un-Answered Questions { SQL Server }

How ssrs maintain security?

1092

What is the difference between count and distinct count?

891

Can you name a few encryption mechanisms in sql server?

951

What is normalization? Describe its different types.

1111

What is the concept of optimization?

1066

What is trace flag in sql server?

1034

What is database black box testing?

1037

How to find the version of sql server? : sql server database administration

1122

What is bulkcopy in sql?

953

Can you force a query to use a specific index?

954

What is a schema in ms sql server 2005?

982

How does stuff differ from the replace function?

1021

How do I view a stored procedure in sql server query?

936

What is a periodical index?

934

What is spid in sql server profiler?

1116

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