Monday, March 7, 2011

SQL Server Interview Questions (Part 2)

Few days back, i went for an interview , following questions were asked
  • How to Performance Tune a Stored Procedure?
  • Type of Triggers?
  • How to get the old value of a field from a trigger when updating a table?
  • What is the difference between horizontal partition and vertical partition?
  • if we have three parameters in the where condition (query has the joins with two or more tables table1.filed1=4 and table2.field2=5 and table3.field3=1)
    what will be the Order of execution of the where condition
    Which condition would be executed first i.e. field1 or field2 or field3?
  • What are the disadvantages of the cursors?
  • A stored procedure has cursors in it, how we can eliminate the cursors?
  • What is the difference between temporary table and table variable?
  • How to restore the Differential Backup?
  • What are Backup Types and difference between them?
  • What are Replication Types, What is snapshot replication?
  • What is the difference between Replication and Mirroring?
  • Can a sub report in Crystal Reports can have another sub report?
  • What is log shipping?
  • Should we normalize the Database on more than 3rd Normal form?


Share This