Interview questions

DB Administration interview questions – page 21

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

  1. What are the different methods of loading dimension tables?

  2. Do you see any reason I might not be a good fit for this position?

  3. What is referential integrity and how can we achieve it?

  4. How can you determine query use full table scan?

  5. Explain the structure of Adaptive server enterprise?

  6. What is the Difference between PowerPlay transformer and power play reports?

  7. What are the different types of segments?

  8. How do you remove duplicates without using remove duplicate stage?

  9. Differentiate between Hashfile and Sequential File?

  10. Why should you put your data warehouse on a different system than your OLTP system?

  11. Why should I go to all the trouble of creating a database when I have a perfectly good Excel Spreadsheet?

Companies that ask DB Administration questions