SQL:

1) What is Index

2) What are the different types of Indexes

3) Can we assign indexes to VIEW

4) What is materialised view and it's rules

5) What is output parameter in stored procedure

6) Write down SP for Output parameter

7) Performance Tuning

8) Try Catch Block

9) What is the difference between Temp Table and Table Variable

10) What is the Difference between function and SP


SSIS:

1) What type of Transaformations you have used

2) We have multiple text file in folder. How to load into DB and we don't want to import from subfolder

3) What is lookup. How to use in your project

4) How to write dynamic package

5) How to handle error in your package

6) How to update row in SSIS

7) What is checkpoint