This list is based on either questions I've been asked in interviews or questions fellow DBAs have been asked.Add your questions to the comments and I'll add them to the list
1.Why should you not put a clustered index on your Identity column?
2.Given a Authors table , how would you find the author with the 3rd highest book sales?
3.What is a CROSS JOIN? Explain and give an example
4.Explain statistics. How often are they updated?
5.If confronted with a sudden poorly running query , how would you troubleshoot?
6.Is there a difference between a Primary Key and a Unique Key?
