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?

950

Explain why variables called the most powerful component of ssis?

1095

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

968

What is precedence constraint?

983

Why variables called the most powerful component of ssis?

1079

Explain error handling in ssis?

1023

What are the types of containers in ssis?

1171

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

980

Explain the use of containers in ssis?

965

Why is the need for data conversion transformations?

1064

What is conditional split?

1070

Can we add our custom code in ssis?

987

Explain the difference between control flow and data flow?

994

What are the purposes and advantages stored procedure?

959

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

1054

Un-Answered Questions { SQL Server }

Explain the difference between control flow and data flow?

994

How to create a testing table with test data in ms sql server?

1083

What is the sql profiler?

940

What stored by the tempdb ? : sql server database administration

1045

Does a server store data?

923

Explain index in sql server?

1012

How to drop an existing stored procedure in ms sql server?

1032

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

900

Explain for xml explicit mode?

974

What are sql servers used for?

1047

What is perspective, have you ever created perspective? : sql server analysis services, ssas

914

How can I change procedure name in sql server?

1050

What is the use of RDBMS?

1004

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1039

What are system databases into sql server (2005/2008)?

999

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