Interview questions

DB Administration interview questions – page 8

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

  1. What is the transaction size and array size in OCI stage?how these can be used?

  2. What is Dimensional Modelling

  3. How to enable security in cognos connection in cognos report net

  4. What is the purpose of exception activity in data stage 7.5?

  5. What is degree of a Relation?

  6. What is a deadlock ? Explain .

  7. How to implement slowly changing dimentions in Datastage?

  8. What is Dimensional Modelling? Why is it important ?

  9. Different types of table join.

  10. What is ER Diagram

  11. When is a database is not a database?

  12. What are modeling tools available in the Market?

  14. What is a deadlock and Explain

  15. Which columns go to the fact table and which columns go the dimension table?

  16. What is job control?how it is developed?explain with steps?

  17. Explain about openEdge ABL in terms of taking the perspective of the developer?

  18. What is DDL, DML?

  19. Explain the benefits you can get from Mainframe connect?

  20. Explain about Mirror Activator Disk mirroring?

  21. What about DML changes dynamically?

  22. Explain about SonicMQ?

  23. Explain Commit and Roll back?

  24. Explain about the Data integration suite features?

  25. How to find errors in job sequence?

  27. What is the Difference between OLTP and OLAP?

  28. What is a cluster Key ?

  29. Explain about the Sybase group?

  30. What is Weak Entity set?

  31. What is the definition of normalized and denormalized view and what are the differences between them

  32. In Microstrategy, how can you direct the sql generated to use a specifc table.

Companies that ask DB Administration questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide