SQL :
  1. What is INDEX? What are different types of Indexes?
  2. Difference between CLUSTERED and NON CLUSTERED INDEX
  3. Can we create Clustered Index without Primary Key?
  4. How many clustered and non clustered indexes we can create on a table?
  5. Difference between TempTable and Table Variable?
  6. Can we create table variable and temp table in Procedure and Functions?
  7. Can we create Indexes on Table Variable and Temp Table?
  8. Which is faster Temp Table or Table Variable?
  9. What is Execution Plan?
  10. What will be the Output for All Join, UNION and UNION ALL for below Tables
  1. Table A Table B
1
1
     
    B. Table A Table B
1 1
1
SSIS:
  1. What are the different Containers in SSIS?
  2. What are the difference between these Containers?
  3. What is meant by Precedence Constraints?
  4. What is SCD?
  5. What are the Types of SCD?
SSRS:

  1. What is Data Driven Subscription?
  2. Key Encryption?
  3. For which report we ser Toggle Property?
  4. What is Filter/Parameterised Reports?