p.s. You might want to spend some time validating and expanding the answers to your interview questions. Some are totally wrong, many are so vague as to not be answers.
eg: (from http://sqlserverquest.blogspot.com/2010/12/sql-server-interview-questions-and_21.html)
Difference between delete and truncate?
Data deleted with truncate command cannot be roll back one the transaction is committed. While data deletion with delete command can be roll back even if the transaction is committed.
That's incorrect on both points.
What are indexes in SQL Server?
Indexes are used to search the data in the database in well-mannered approach. Data can be searched by user without going into entire database.
Errr.....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability