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?

1140

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

1008

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

BirlaSoft, Verifone,

1112

Explain DBCC?

QuestPond,

960

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

1071

Explain about service Broker functions?

1032

Can you tell me about the concept of ER diagrams?

1068

What are different type of Collation Sensitivity?

1001

Which one is faster delete/truncate? Why?

Infosys,

1 1815

Difference between DELETE and TRUNCATE?

TCS,

1047

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

QuestPond,

1013

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

Arigo Infotech,

995

What is Dependency Injection and provide example?

1117

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

QuestPond,

1066

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

1230

Un-Answered Questions { SQL Server }

In what three ways is the return statement used in a stored procedure?

1008

How to grant a permission in ms sql server using "grant execute" statements?

1092

How to create a new schema in a database?

1151

How is a full-text index updated?

954

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1066

What are various limitations of the views?

1051

What stored procedure can you use to display the current processes?

893

Explain index in sql server?

1012

Where do you find the default Index fill factor and how to change it?

1063

What are the different types of upgrades that can be performed in sql server?

1176

How can you stop stored procedures from recompiling?

900

What is the difference between osql and query analyzer?

994

Explain what is “asynchronous” communication in sql server service broker?

917

Can we call future method from trigger?

937

What are the limitations in ssrs on sql server express edition?

186

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