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?

902

Explain why variables called the most powerful component of ssis?

1017

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

925

What is precedence constraint?

946

Why variables called the most powerful component of ssis?

1035

Explain error handling in ssis?

979

What are the types of containers in ssis?

1109

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

934

Explain the use of containers in ssis?

903

Why is the need for data conversion transformations?

993

What is conditional split?

1016

Can we add our custom code in ssis?

955

Explain the difference between control flow and data flow?

948

What are the purposes and advantages stored procedure?

908

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

1006

Un-Answered Questions { SQL Server }

What is the usage of the sign function?

1033

Difference between aggregate functions of sql?

1051

Explain the different index configurations a table can have?

903

Define msdb database?

986

What is the command used to recompile the stored procedure at run time?

1038

what is dbcc? : Sql server database administration

982

what is package and it uses and how can u call a package

1970

Explain how you can configure a running aggregate in SSRS?

159

Tell me about pre-defined functions of sql?

1080

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2339

How to return the date part only from a sql server datetime datatype?

1044

1 01 101 01010

2014

Can a table be created inside a trigger?

934

Explain encryption of entire databases without the need for application changes in sql server 2008?

1008

Explain view in sql server?

1023

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