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?

1008

What are the different index configurations a table can have?

955

Explain difference between cross join and full outer join?

1003

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

1123

Explain what is use of dbcc commands?

1052

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

1018

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

956

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

938

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

968

Explain what are commit and rollback in sql?

927

please differentiate between delete and truncate?

989

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

1036

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?

1035

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

992

Explain what is scheduled job and how to create it?

951

Un-Answered Questions { SQL Server }

Define full outer join?

949

Explain about service Broker functions?

1028

What is the use of set nocount on/off statement?

1094

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1053

What number sorts of privileges are accessible in sql?

1031

How do use Having,Group by,Group function in SQL?

1737

Define Joins?

1024

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

879

What is report snapshot in ssrs?

266

What is log cache in sql server?

1033

What is the cpu pressure?

1034

What is transactional replication?

958

Your table has a large character field there are queries that use this field in their search clause what should you do?

879

What is etl - extraction, transformation, and loading?

916

What are sub reports?

201

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