1. Tell me about yourself?
  2. What is your role in your project?
  3. Performance Tuning
  4. Indexes and Types of Indexes
  5. What is User Defined Functions? What are the different types of UDF?
  6. What is meant by Triggers? What are the different types of Triggers?
  7. If we have delete Trigger on Table and We are trying to to Truncate it, what will happen?
  8. What is NO COUNT ON/OFF?
  9. What are the 3 ways to get number of rows from table?
  10. Difference between DELETE and TRUNCATE?
  11. What are 3 ways to get Nth Highest Salary?
  12. Top 3 Salary as per the DeptID
  13. What is VIEW?