Whenever I go for interview for Software engineer job I face this question for SQL Server 2005, so my advice for those who want to get success in interview must have answers for the following questions.
What are indexes and what types are they?
What is the difference between Stored Procedures and Functions?
What is the core difference in Clustered and Non-Clustered Indexes?
What is the difference between Unique Key and Primary Key?
What is Normalization?
What are the Joins and its types?
Differentiate between INNER JOIN and OUTER JOIN?
What is Cross JOIN?
I'll give post answers for this question later.