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?

1132

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

1001

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

BirlaSoft, Verifone,

1107

Explain DBCC?

QuestPond,

956

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

1069

Explain about service Broker functions?

1028

Can you tell me about the concept of ER diagrams?

1063

What are different type of Collation Sensitivity?

997

Which one is faster delete/truncate? Why?

Infosys,

1 1802

Difference between DELETE and TRUNCATE?

TCS,

1047

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

QuestPond,

1011

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

Arigo Infotech,

992

What is Dependency Injection and provide example?

1113

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

QuestPond,

1061

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

1226

Un-Answered Questions { SQL Server }

What is difference between rollback immediate and with no_wait during alter database?

1086

Does order by actually change the order of the data in the tables or does it just change the output?

1138

How to delete duplicate records based on single column from a table?

1047

Can an automatic recovery be initiated by a user?

998

What are the new features are introduced in sql server 2012 reporting services?

149

What are different types of views?

944

Explain about builtinadministrator?

1049

How are the exceptions handled in sql server programming?

1060

What types of replication are supported in sql server?

1061

What are .mdf files?

935

Can group functions be mixed with non-group selection fields in ms sql server?

939

What is normalization? Describe its different types.

1102

Define master database?

1056

What is lookup override?

1022

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

946

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