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?

996

Explain what are the events recorded in a transaction log?

954

What is pessimistic concurrency?

937

Do you know the isolation level that sql server support?

937

Explain optimistic and pessimistic concurrency?

952

Explain the various types of concurrency problem?

1146

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

1027

What is sql server locking?

957

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

932

Explain the benefits of user-defined functions?

1007

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

867

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

963

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?

948

Un-Answered Questions { SQL Server }

How to transfer data from a cursor to variables with a "fetch" statement?

1039

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

1080

What is mssql?

951

Explain the microsoft sql server delete command? : SQL Server Architecture

1027

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

907

how will add additional conditions in sql?

1034

When is update_statistics command used?

1012

Which autogrowth database setting is good?

1013

Explain logical operators in sql server?

1052

How can I get data from a database on another server?

948

What is the maximum rows in sql server table?

876

Where cross join is used?

917

What are cursors stored procedures and triggers?

960

What is named calculation? : sql server analysis services, ssas

946

Does index slows down insert statements?

953

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