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?

1189

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

1071

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

BirlaSoft, Verifone,

1157

Explain DBCC?

QuestPond,

1016

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

1111

Explain about service Broker functions?

1089

Can you tell me about the concept of ER diagrams?

1121

What are different type of Collation Sensitivity?

1048

Which one is faster delete/truncate? Why?

Infosys,

1 1895

Difference between DELETE and TRUNCATE?

TCS,

1096

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

QuestPond,

1058

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

Arigo Infotech,

1059

What is Dependency Injection and provide example?

1178

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

QuestPond,

1122

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

1273

Un-Answered Questions { SQL Server }

Why we need sql server?

1015

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1062

How do I get to sql server configuration manager?

1062

What is use of @@ spid in sql server?

1273

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1095

What are alternate keys?

1031

optimization techinques

2721

Define Wed Edition in SQL Azure?

102

What is the maximum row of a size?

1068

What are sql server procedures?

1037

What is difference between delete and truncate commands?

1172

How to add additional conditions in SQL?

1069

plss anybody specify tha constrian management system in dbms

2205

What is exclusive locks?

1012

What is “asynchronous” communication in sql server service broker?

1080

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