Interview questions

DB Administration interview questions – page 6

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

  1. Explain about Sybase 365?

  2. What is an Oracle view

  3. Explain about Progress Apama?

  4. What is a cursor? Why do you need them? What are the different kinds of cursor?

  5. What is Parallel Server

  6. What is a common data source for the central enterprise data warehouse?

  7. What is the difference between Multiload & Fastload interms of Performance?

  8. How to create a computer program that computes the monthly interest charge on a credit card account?

  9. What is Normalization? Explain all the normal forms?

  10. What is a Database instance ? Explain

  11. What is an Index ? How it is implemented in Oracle Database ?

  12. What is a schema

  14. Name some of the real time data-warehousing tools.

  15. Where the procedures are stored in database?

  16. Detail about the environment of Openedge?

  17. If the size of the Hash file exceeds 2GB..What happens? Does it overwrite the current rows?

  18. What Snow Flake Schema?

  19. What is meant by metadata in context of a Datawarehouse and how it is important?

  20. What the default privileges which get assigned ?

  21. What are the vaious ETL tools in the Market

  22. Define and explain about progress?

  23. Online Analytical Processing

  24. What is a Relation Schema and a Relation?

  25. What is Functional Dependency?

  27. What are Aggregate tables?

  28. What are the types of synonyms

  29. What does a control file contains

  30. What is the difference between start schma and Fsldm?

  31. What is DML Compiler?

  32. What rule optimizations are possible in SQL query tuning?

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