SQL:

1) What is Database Normalization? Explain in Detail

2) Difference Between Table Variable and Temporary Table

3) Query Optimisation

4) String Related Question : Substring, Length

5) Write a Procedure to Swap 2 Numbers without using 3rd Variable

6) How to Delete Duplicate Record without Primary Key

7) Difference Between ISNULL() and COALESCE()

8) What is ANCHOR query in sql


SSIS:

1) What is System and User level Variable in SSIS

2) How Data Mining activity will carried out in SSIS

3) Difference between Control Flow and Dara Flow

4) What is Checkpoint

5) Which task will use to update the query

SSRS:

1) What is SSRS

2) Types of Reports

3) Explain RDL

4) Roles in SSRS

5) Write steps of subscription