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

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1005

Explain why variables called the most powerful component of ssis?

1176

Explain the use of containers in ssis and also their types?

1019

What is precedence constraint?

1039

Why variables called the most powerful component of ssis?

1128

Explain error handling in ssis?

1078

What are the types of containers in ssis?

1235

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1027

Explain the use of containers in ssis?

1018

Why is the need for data conversion transformations?

1113

What is conditional split?

1141

Can we add our custom code in ssis?

1040

Explain the difference between control flow and data flow?

1061

What are the purposes and advantages stored procedure?

1020

Determine when to use stored procedure to complete sql server tasks?

1115

Un-Answered Questions { SQL Server }

What is lookup override?

1082

What do we need queues in sql service broker?

1124

How to create a new login name in ms sql server?

1109

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

1040

What do you mean by a Composite primary key?

1192

Explain few examples of stored procedure over triggers?

1118

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1067

what are the three command line utilities and what are their primary functions?

153

How to delete existing rows in a table?

1250

How would you use user_constraints table in DB?

1062

Describe different Processing Modes offered by SSRS?

257

What happens if null values are involved in datetime operations?

1023

what are the different ways to return the rowcount of a table?

1056

Why do we need normalization?

978

What are the different types of replication are there in sql server 2000?

1090

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