1. What is database normalization?
2. What is a trigger & cursors?
3. What is an Index? & what are the types of indexes available with SQL Server?
4. Can you tell me the difference between DELETE & TRUNCATE commands?
5. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
6. What do you mean by COLLATION?
7. What is a Join in SQL Server? & Can you explain the types of Joins that we can have with Sql Server?
8. What are cursors? Name four types of cursors and when each one would be applied?
9. How do you check the performance of a query and how do you optimize it?
10. What id de-normalization and when do you do it?
11. How do you find the number of rows in a table?
12. Explain basic SQL queries with SELECT from where Order By, Group By-Having?
13. What is a job & tasks?
14. How do you know which index a table is using? & which virtual table does a trigger use?
15. How can you get @@error and @@rowcount at the same time?