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

Describe triggers features and limitations?

944

What is ms sql server service broker?

947

Please explain what is “asynchronous” communication in sql server service broker?

892

What are the components of sql server service broker?

959

Tell me what are the essential components of sql server service broker?

902

Do you know how to implement service broker?

897

Explain what is the main purpose of having conversation group?

894

Explain sql server service broker?

941

Tell me what do we need queues in sql service broker?

940

How to encrypt data between dialogs?

1044

Explain isolation levels that sql server supports?

1001

Explain what is lock escalation and what is its purpose?

894

Explain different types of lock modes in sql server 2000?

898

What are the different types of lock modes in sql server 2000?

896

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

903

Un-Answered Questions { SQL Server }

What is the difference between char and varchar2 datatype in sql?

1023

Are all views updatable ?

1113

How to provide login information for a new odbc dsn?

995

What is join query?

854

Explain index in sql server?

973

What are the difference between primary keys and foreign keys?

929

What is the difference between a unique key and primary key?

909

what is sql server? : Sql server database administration

947

What is transaction server isolation?

984

Explain trigger and trigger types?

924

What are the different types of Indexes available in SQL Server?

966

When do you think a developer should use sql server-based cursors?

992

What are the differences between clustered and non-clustered index?

976

What is the osql utility?

927

Explain aggregate functions?

1039

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