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?

1057

What is ms sql server service broker?

1048

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

982

What are the components of sql server service broker?

1070

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

993

Do you know how to implement service broker?

974

Explain what is the main purpose of having conversation group?

994

Explain sql server service broker?

1026

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

1054

How to encrypt data between dialogs?

1171

Explain isolation levels that sql server supports?

1086

Explain what is lock escalation and what is its purpose?

987

Explain different types of lock modes in sql server 2000?

986

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

997

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

1000

Un-Answered Questions { SQL Server }

Comment,Datatypes are unlimited

2110

how to take backup bcp out for a column in table in sql server?

2148

what is a transaction and what are acid properties? : Sql server database administration

1091

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

954

How many types of local tables are there in sql server?

980

What are various limitations of the views?

1096

Explain what is use of dbcc commands?

1143

What is data modification?

1023

Which tcl commands are available on the sql server?

1143

What is the difference between functions and stored procedures?

1226

What is a transact-sql statement?

1131

What is the full meaning of dml?

1004

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1056

Explain what is the difference between union and union all?

1070

What is user-defined scalar function?

1010

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