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?

1091

Explain what are the events recorded in a transaction log?

1053

What is pessimistic concurrency?

1023

Do you know the isolation level that sql server support?

1005

Explain optimistic and pessimistic concurrency?

1034

Explain the various types of concurrency problem?

1241

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

1140

What is sql server locking?

1036

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

1014

Explain the benefits of user-defined functions?

1124

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

940

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

1047

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

1022

What do you know about normalization and de- normalization?

970

What is built-in function?

1058

Un-Answered Questions { SQL Server }

what are defaults? : Sql server database administration

1163

Define master database?

1141

Which tcp/ip port does sql server run on? How can it be changed?

1082

What is 1nf 2nf?

1060

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

957

Tell me extended events in sql server 2008?

1053

What samples and sample databases are provided by microsoft?

1089

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1045

Explain index in sql server?

1066

How to convert a unicode strings to non-unicode strings?

1157

What is the purpose of a table?

995

Why it is recommended to avoid referencing a floating point column in the where clause?

1017

what is a self join? Explain it with an example? : Sql server database administration

1002

What is a transactions?

1087

ow to bring suspect mode datbase online from scratch

1856

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