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

What is optimistic concurrency?

992

Explain what are the events recorded in a transaction log?

948

What is pessimistic concurrency?

931

Do you know the isolation level that sql server support?

937

Explain optimistic and pessimistic concurrency?

948

Explain the various types of concurrency problem?

1144

Do you know what are the differences between lost updates and uncommitted dependencies?

1023

What is sql server locking?

951

Do you know what guidelines should be followed to help minimize deadlocks?

932

Explain the benefits of user-defined functions?

1003

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

857

Explain how dts is used to extract, transform and consolidate data?

955

Explain the difference between functions and stored procedures in sql server?

936

What do you know about normalization and de- normalization?

881

What is built-in function?

946

Un-Answered Questions { SQL Server }

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1076

Does index slows down insert statements?

950

What is coalesce in sql server?

1004

Describe different Processing Modes offered by SSRS?

234

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1102

Explain about service Broker functions?

993

What is a cursor, index in sql?

1031

Explain the etl (extraction, transformation, and loading)?

954

What is create command?

938

Why functions are used in sql server?

914

What are key constraints?

935

What is report snapshot in ssrs?

253

what are user defined datatypes and when you should go for them? : Sql server database administration

974

Can you explain what is indexed view? How to create it?

861

What is a document index?

987

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