SQL
  1. What is mean by primary key?  difference between primary key and foreign key?
  2. Difference between Where and having?
  3. Difference Between Delete and Truncate?
  4. What is mean by Trigger?
  5. What is functions and procedures?  difference between triggers, procedures and functions?
  6. Explain query plan 
  7. What is index ? explain in detail
  8. What is the difference between  clustered and nonclustered indexes
  9. Write query to find duplicate records
  10. What is TSQL
  11. What is constraint in  SQL
  12. What is normalisation
  13. Difference between temporary table and table variable 
  14. Identity column and unique column
  15. Explain different isolation levels in SQL server
  16. What is view
  17. What is mean by Cursor 
SSIS
  1. Explain SSIS project
  2. What are the ways to to deploy SSIS packages
  3. Difference between Union All transformation and Merge transformation
  4. What is a surrogate key 
  5. What is mean by OLAP?  difference between OLAP and OLTP 
  6. What is BCP
  7. What are different SSIS  log providers
  8. Advantages of using SSIS packages  over Stored procedures
SSRS

  1. Example of SSRS