SQL:
  1. What is the difference between DELETE, TRUNCATE and DROP
  2. What is triggers? explain its types
  3. What is index and explain its types
  4.  difference between cast and convert
  5.  how to optimise query
  6.  difference between stored procedures and functions
  7.  features of SQL server 2016
  8. CTE, Recursive CTE and their common examples
  9. Explain different ranking functions
  10.  difference between unique key and primary key
  11.  tricky questions on joins
  12.  what is cursor and explain its types
  13.  order of query execution
SSIS:
  1. What is control  and data flow
  2. Which transformation you have used
  3. Difference between Union all and merge
  4. Difference between blocking, non-blocking and semi blocking transformation with example
  5.  lookup transformation
  6.  conditional split and multicast
  7.  if table a having 15 records in S1 Server and  table b having 10 records in S2 server which are same like table a. Now I want to insert those remaining 5 records into table b from table a.

 how will you perform this