Data Warehouse Developer interview questions – page 31

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

Advertisement
  1. What is a slide sorter?

  2. Explain in brief oracle database objects.

  3. What are the Back ground processes in Oracle?

  4. You looking for end to end DW experience? For this, you should have born 15yrs ago. All DW has been implemented, and now maintainance remains

  5. Do you have any experience?

  6. Can you tell me about your project?

  7. What is difference between Round & truncate?

  8. What is ceil and floor in Oracle? Give the difference between Ciel and Round?

  9. How to read line no 10 to line no 15 in Unix from a file?

  10. If we are using a sorter then an aggregate in a mapping and we do not check the check box of sorted input, what will happen?

  11. What was the most stressful aspect of your last project and how did you deal with it?

  12. How many members in your family and who supported you to come in IT Industry?

  13. Advertisement
  14. What are the roles and user accounts created automatically with the database?

  15. What are the tools you know?

  16. What is Trigger at one Line?

  17. How tuning can be done on Query?

  18. Which two parameters cannot be used together to specify the archive destination?

  19. What is the next step in the process?

  20. How will you copy the structure of a table without copying the data?

  21. Would you rather be a jack of many trades or a master of one?

  22. How to join two tables without using the Joiner Transformation?

Advertisement