The HR contact was very pleasant and seemed impressed with both technical and life skill sets being offered. The second interview was not interested in the person as much as specific answers. If I was not on track toward the response they were expecting, I was interrupted and told we were moving on to the next topic.

Difference between table truncate and delete.

Difference between clustered and non-clustered index.

Difference between abstract class versus interface.

How would you handle a 1/2 million record import file in the wrong format that has to be processed in 4 hours?

If a manager dropped a one-line requirement on your desk for a project and said you had one year, what would your approach be?

If you have 4 equally capable employees on the team and are informed you have to release two of them, what would your approach be?