Just Crack Interview

Data Warehouse Developer interview questions – page 2

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

Advertisement

  1. What is the Query Optimizer. How you optimize your qeury.

  2. What is a transaction isolation level and What is the advantage of it? What are different options that we set for a transaction isolation level? Transaction isolation levels are used when we go for transactions in stored procedures used in Transact SQL.

  3. I have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

  4. Tell me about a specific task you undertook, which was a challenge for you?

  5. When do you expect to make your final decision?

  6. What is difference between function and procedure?

  7. Using subquery how can i calculate working days in a month?

  8. How do you change a password for an existing user via mysqladmin?

  9. Does SQL SERVER Supports "Finally" block?

  10. I'am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done.

  11. Explain about managing data tasks?

  12. The default type of Constants and variables supported by TSLare..

  13. Advertisement

  14. What is the difference between Power Center & Power Mart?

  15. Provide all the built in string function of SQL SERVER

  16. Where do we use semi and non additive facts

  17. What is the metadata extension?

  18. State some criteria`s and their effects on a ms access database?

  19. Without matching columns in two tables. how can you join

  20. State the criteria which a trusted publisher should meet before adding him?

  21. Can any one give me an example for factless fact table ?If your answer is studunt attendence registration,could you plese give me explanation for this ?

  22. What is partitioning? What are the types of partitioning?

  23. What are the various transformation available?

  24. How to calcuate the second highest salary of he employee

  25. Tell me about a time you got totally fed up on the job. What did you do after that?

  26. Advertisement

  27. How can I open an MS Access database that has been converted to a current version?

  28. How do you select a row using indexes in DB2?

  29. What is Sql Native Client?

  30. What is maximum size of a database in MySQL?

  31. How to write query to Delete the records in child table and corresponding records in parent table

  32. What?s the default port for MySQL Server?

Advertisement
Advertisement