SQL Server Interview Questions for 1 Year Experience

1. What is Primary key, unique key and difference between them?
2. What is index? Types of index?
3. What is a stored procedure? Why it is better than inline query?
Hint: Stored Procedure is precompiles and has a execution plan. Hence faster execution.
4. You might be asked to write simple query
5. What is inner join?
6.what is DBMS?
7.what is RDBMS?
8.What is Self Join?
9.what are the types of join?
10.what is diff b/w sql server2005 and 2008?

Posted in: SQL