Round 1
  1. What will be the output of below for INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN
Table 1 Table2
1 1
1 1
1 0
0 0
0 NULL
NULL NULL
NULL NULL
  1. Explain different ranking functions in SQL Server?
  2. How to display and remove duplicate data from table?
  3. Explain SSIS Package deployment? what are the different ways available to deploy SSIS  package?
  4. Explain synchronous and asynchronous transformations in SSIS?
  5. Explain blocking and nonblocking in SSIS
  6. How can we improve the performance of an update query for 20 million records ?
  7. What are the different types of ssrs reports?
  8. What is mean by subscription in ssrs?
  9. Difference between ROW_NUMBER and DENSE_RANK
Round 2
  1. How can we send bad data to destination without failure of package?
  2. How can we rollback all DFD in below scenario?
DFD1- Success
DFD2- Failed

DFD3- Failed