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 the difference between TRUNCATE and DROP?

1 1200

What are the disadvantages of using querystrings to send data from one page to another?

1 1099

What is the difference between ddl,dml and dcl commands?

BirlaSoft, Verifone,

1 1166

Explain DBCC?

QuestPond,

1 1022

Explain what role entity and relationship play in an ER diagram.

1 1122

Explain about service Broker functions?

1 1097

Can you tell me about the concept of ER diagrams?

1 1131

What are different type of Collation Sensitivity?

1 1058

Which one is faster delete/truncate? Why?

Infosys,

1 1918

Difference between DELETE and TRUNCATE?

TCS,

1 1106

What is Cross Join and in which scenario do we use Cross Join?

QuestPond,

1 1069

What is a View ? Can we insert, Update and delete a view?

Arigo Infotech,

1 1071

What is Dependency Injection and provide example?

1 1187

Can two different columns be merged into single column? Show practically?

QuestPond,

1 1134

What is the difference between DataRow.Delete() and DataRow.Remove()?

1 1286

Un-Answered Questions { SQL Server }

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1034

What is in place upgrade in sql server?

1113

What is a scheduled job or what is a scheduled task?

1019

What is the primary use of the model database?

1141

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?

1200

How can we solve concurrency problems?

1110

What are wait types?

1219

Why and when do stored procedure recompile?

1042

What are the different SQL Server Versions you have worked on?

1071

How to enter binary string literals in ms sql server?

1231

What is clustered index

1069

What is normalization and what are the advantages of it?

1042

List the ways in which dynamic sql can be executed?

1071

How to convert character strings into numeric values?

1166

When should you use an instead of trigger?

1033

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