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?

900

Explain why variables called the most powerful component of ssis?

1009

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

922

What is precedence constraint?

939

Why variables called the most powerful component of ssis?

1035

Explain error handling in ssis?

979

What are the types of containers in ssis?

1105

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

933

Explain the use of containers in ssis?

901

Why is the need for data conversion transformations?

989

What is conditional split?

1010

Can we add our custom code in ssis?

950

Explain the difference between control flow and data flow?

946

What are the purposes and advantages stored procedure?

900

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

1002

Un-Answered Questions { SQL Server }

What happens if strings are casted into wrong code pages in ms sql server?

1078

What are the export options of ssrs?

167

What is SQL Azure Data sync?

119

Does a sql server 2005 select statement require a from?

981

What is the library index called?

1013

What is the exact numeric data type in sql?

970

What is the default value of an integer data type in sql server 2005?

918

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1901

Is the log file is a part of file group?

987

What is the difference between clustered and non-clustered indexes in ms sql server?

955

how to determine the service pack currently installed on sql server? : Sql server database administration

928

What are the underflow and overflow behaviors on float literals?

1075

Can you force a query to use a specific index?

897

Can you explain different types of locks in sql server?

916

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1976

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