SQL:
  1. Explain types of joins  and how they work?
  2. Explain index architecture?  How index works?
  3. Types of indexes?  Relation between insert and index?
  4. What are functions? Use of Functions?
  5. Explain types of functions with example?
  6. Explain procedures and their types
  7. Difference between Procedures and Functions
  8. What is View? Explain it’s types, use with example
  9. Can we perform DML operations on Views
  10. Identity column? How to ON/OFF identity
  11. Delete vs Truncate on Identity columns
  12. If we delete 5 records from table having an identity column and insert same records again. Then which place these records are inserted and what will be the identity column value of those records?
  13. Difference between DELETE and TRUNCATE
  14. Can we delete records from table using case statments?
  15. Difference between Primary Key and Unique Key?
  16. What is Primary Key and Composite Key with Example?
  17. SQL query optimization techniques
  18. SQL Profiler tuning?
  19. DB restore and Backups
  20. Steps of job scheduling
  21. Ranking functions
SSRS:
  1. Different types of reports and their examples?
  2. Properties of Drill Down, DrillThrough and SubReports?
  3. Chart Reports?
  4. Which types of expressions we can use in SSRS reports?
  5. Parameterised reports
  6. Use and purpose of SSRS reports
SSIS:

  1. Transformation Tasks in SSIS?
  2. Use of Copy Column and Derived Column? Difference between them
  3. Use of LookUp
  4. Difference between Fuzzy Lookup and Fuzzy Grouping?
  5. What is Conditional Split? How it works?
  6. What will be the output of Conditional Split?
  7. Package Configuration Steps and Types?
  8. Package Deployment Types and Steps?
  9. Use of Execute SQL Task?
  10. How to Handle exceptions in SSIS?
  11. How to schedule Packages?
  12. Some questions on your project?