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?

989

What is ms sql server service broker?

992

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

936

What are the components of sql server service broker?

1016

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

941

Do you know how to implement service broker?

928

Explain what is the main purpose of having conversation group?

940

Explain sql server service broker?

977

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

993

How to encrypt data between dialogs?

1107

Explain isolation levels that sql server supports?

1039

Explain what is lock escalation and what is its purpose?

932

Explain different types of lock modes in sql server 2000?

931

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

949

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

950

Un-Answered Questions { SQL Server }

When a primary key constraint is included in a table, what other constraints does this imply?

989

What is difference between equi join and inner join?

950

Does the order of columns in update statements matter?

913

Explain trigger and trigger types?

983

What is the difference between update lock and exclusive lock?

976

What is the difference between a function and a stored procedure?

1070

What is use of @@ spid in sql server?

1213

What is the difference between for xml raw and for xml auto?

1031

Do you know concepts and capabilities of sql server?

1060

What is replication and database mirroring?

1047

How to list all dsn entries on your local machine using odbc_data_source()?

1039

What is microsoft sql server?

974

what's the difference between a primary key and a unique key? : Sql server database administration

950

what are isolation levels? : Sql server database administration

993

Do you know clustered and non-clustered index?

979

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