SQL:
  1. What is Stored Procedure? Advantages and Disadvantages of Stored Procedures
  2. What are aggregate and scalar functions?
  3. Difference between Delete, Truncate and Drop
  4. What is collation?
  5. Explain Index in detail
  6. What is Joins ,join complex query 
  7. What is Trigger?
  8. What is ACID Properties
SSRS:
  1. What is Data Driven Subscriptions
  2. What are the different Types of report
  3. How to deploy SSRS reports
SSIS:  

  1. DW,Fact,Dimension
  2. languages are used in SSAS
  3. Transformation ssis
  4. Derived cols usage