SQL Server Interview Questions (Part 2)

Session on 12-10-13(FA)

· Execute Plan of Query (Sql Server)
· What is Difference between Merge and Merge Join
· Instead of Trigger (Example)
· Print Command Write in Function is Possible or Not
· How To Handle Bottle neck Problems in Sql Server
· Difference between Delete & Truncate
· Difference between Char & Varchar
· Difference between Stored Procedures & Functions
· U Pass Table Variable Parameter to Stored Procedure
· What is Clustered and Non Cluster Indexes? Explain Clearly
· What is B Tree and Explain Leaf Node
· What is Result of
Q-1
Begin Transaction T1
Insert Row1
Begin Transaction T2
Insert Row2
Rollback T2
Commit T1

Q-2
Begin Transaction T1
Insert Row1
Begin Transaction T2
Insert Row2
Commit T2
Rollback T1

· Write a Delete Statement of Duplicate Records(sno,name are Primary Keys)
  Sno,name,amt
  1,aaaa,20
  1,aaaa,30
  1,aaaa,20