SQL:
  1. Difference between SQL Server 2008 and 2012
  2. select * from table name order by 2”  will this query execute or not?
  3. how to update the view?
  4. types of functions
  5. what is schemabinding
  6. explain JOIN and its types
  7. isolation level of SQL server?  which is best? what is default isolation level of SQL server
SSIS:
  1. How to execute SQL command in data flow
  2. types of precedence constraints
  3. how to do insert,  update and delete instead of using CDC and SCD
  4. which types of transformations you have used?
SSRS:

  1. Types of reports you have developed?
  2. difference between tabular and matrix report
  3. report rendering
  4. how to export report data in excel file multiple sheet