SQL:
  1. Write a query to delete duplicate records?
  2. Difference between rank(), dense_rank and row_ number()
  3. What is a data type of getdate()?
  4. I have date like ‘20180908’. Convert it into INT or BIGINT?
  5. Which of the below can not be rollback:
  1. DROP
  2. TRUNCATE
  3. DELETE
  1. DECLARE @Varibale VARCHAR and DECLARE @Variable VARCHAR(20). Which is Wrong?
SSIS:
  1. I have 2 tasks which are independent. After completion of each task, I want to send an email that task is complete. Create a package for it.
  2. I have Oracle Source. Which connection I should use?
  3. Difference between variable and Parameter?
  4. What are the different types of Containers?
  5. What types of Transformations you have used?
  6. What is computed columns?
  7. Which versions you have used? What are the Features?
  8. Deployment Utility
  9. SCD and CDC
  10. FOR LOOP and FOR EACH LOOP Container
  11. Deployment Steps
  12. Empid, empname, mgrid
O/P: empid, ename, mgrname
  1. Fuzzy Lookup
SSRS:

  1. What are the different types of reports?
  2. How many Non Clustered index in any table
  3. Max Columns
  4. SSIS Configurations?