Just Crack Interview

Data Warehouse Developer interview questions – page 7

921 questions. Tap “Show answer” to check yourself.

Advertisement

  1. What are the different types of joins?

  2. State some of the uses append query?

  3. Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?

  4. What is mapping parameter and mapping variables

  5. How do you eliminate duplicate values in DB2 SELECT ?

  6. What is Full load & Incremental or Refresh load?

  7. Explain the steps for this message "could not delete from the specified tables"?

  8. Provide me the employees list?

  9. Where does Profiler store its temporary data in SQL Server 2005?

  10. How to tell the team about his past work performance?

  11. WHT ARE THE AGGREATE FUNCTIONS?

  12. Can we create clustered index on non primary key column

  13. Advertisement

  14. How do we call shell scripts from informatica?

  15. What does this return? select (1324 & 1024)

  16. Can you any body tell me suppose database is suspect mode. how can take to normal?

  17. Which system table contains information on constraints on all the tables created?

  18. My source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

  19. Can I use ExecuteReader() in if-else. Because in my code which is in C# ExecuteReader() in if is executing and in else it is not please tell me the solution.

  20. What is DML,DDL?

  21. What is your long-range objective?

  22. In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?

  23. What is the difference between Inner join and full outer join in terms of the Number of rows returned?

  24. How To delete duplicate record from a particular table?

  25. What skills do use when you need to influence the way other people think?

  26. Advertisement

  27. Explain about the various features present in MS Access?

  28. Write a procedure to return the month and the number of developers joined in each month (cursor )

  29. What does the Queue Reader Agent do in SQL Server 2005 replication?

  30. In which order do you perform an upgrade to SQL Server 2005 for replicated databases?

  31. Describe a situation in where you had a task that was quite demanding and what was the result of it?

  32. Which one is better performance wise connected/un-connected lkp?why?

Advertisement
Advertisement