1. Tell me about your project?
  2. How data gets loaded? How it is handled in SSIS?
  3. After Data loading how it gets analysed for any Duplication or Data validation?
  4. Explain Indexing in Detail
  5. Difference between Stored Procedure and Function. Can we update table using UDF?
  6. Difference between Temp Table and Table Variable? Why and When to USe Temp Table? Why and when to use Table Variable?
  7. Can we use Temp Table and Table Variable in UDF?
  8. Difference between Delete, Truncate and Drop
  9. Output of the Following for VArious JOINS
Table A Table B
1 1
2 0
3 1
NULL NULL
  1. Update “M with F” and “F with M” in below table (Use Case)
Id
Name
Sex
Salary
1
a
M
1000
2
b
F
2000
3
c
M
3000
4
d
F
4000
  1. What will be the output of below query?
SELECT id, YEAR(billdate) as billyear
FROM Employee
WHERE billyear>=2010
What will be the error? What are the ways to remove errors (Expecting 2 ways)
  1. SELECT (CASE WHEN NULL=NULL then ‘Yup’ ELSE ‘nope’ END)
What will be the output of the above query?

  1. How to find Nth Highest Salary?
  2. Difference between ROW_NUMBER(), RANK() and DENSE_RANK()
  3. Difference between UNION and UNION ALL? Which is Faster?
  4. Are Join Conditions Required?
  5. Can we Join 2 Tables without JOIN keyword?
  6. Explain Index in Detail. What are the types of Indexes? What is meant by Composite Index? How to set Clustered Index after table Creation? 
  7. UNIQUE vs PRIMARY KEY
  8. What is meant by CTE? Why to use it? What are the drawbacks of CTE?
  9. Explain Query Execution Plan
  10. What are the different Components of SSIS?
  11. What tasks you have done in SSIS Project?
  12. Have you created Stored Procedure in your project?
  13. What is SSIS package deployment? What are the different methods available to deploy SSIS Package?
  14. Difference between MErge, Lookup and Union All Transformations
  15. What is SSRS?
  16. Types of Reports you have created in your project
  17. How to create Drill Down and Drill Through Reports? Why to use Advanced Mode? What it exactly does?
  18. How to deploy SSRS reports?
  19. What is report Subscription?
  20. What are the types of Render format?
  21. How to limit render format upto specific limit like upto PDF only?
  22. How to schedule reports?
  23. What is Cascade report/parameters ?
  24. What is SubReport? How execution done?
  25. What is Reporting Server? What is the use of it?
  26. What is meant by DataSource in SSRS? What is the difference between Shared Data Source and Integrated Data Datasource?
  27. What is the difference between Table and Matrix? What is Tablix?