40 TOP Memory Management Interview Questions and Answers

List of top 40 most frequently asked memory management interview questions and answers pdf download free

Memory Management Interview Questions and Answers List

  1. What is the significance of having storage clause?
  2. What is the functionality of SYSTEM table space?
  3. How does Space allocation table place within a block?
  4. What is the role of PCTFREE parameter is storage clause?
  5. What is the OPTIMAL parameter?
  6. What is a shared pool?
  7. What is mean by Program Global Area (PGA)?
  8. What is a data segment?
  9. What are the factors causing the reparsing of SQL statements in SGA?
  10. What is Database Buffers?
  11. What is dictionary cache?
  12. Which parameter in Storage clause will reduce number of rows per block?
  13. What is meant by free extent?
  14. How will you force database to use particular rollback segment?
  15. How can we organize the tablespaces in Oracle database to have maximum performance?
  16. How will you swap objects into a different table space for an existing database?
  17. What is redo log buffer?
  18. What is meant by recursive hints?
  19. How can we plan storage for very large tables?
  20. How will you estimate the space required by a non-clustered tables?
  21. It is possible to use raw devices as data files and what are the advantages over file system files?
  22. What is a Control file?
  23. How will you monitor rollback segment status?
  24. How will you monitor the space allocation?
  25. Why query fails sometimes?
  26. How the space utilization takes place within rollback segments?
  27. How will you create multiple rollback segments in a database?
  28. What is a rollback segment entry?
  29. What is hit ratio?
  30. What are disadvantages of having raw devices?
  31. What is use of rollback segments in Oracle database?
  32. What is advantage of having disk shadowing / mirroring?
  33. How redo logs can be achieved?
  34. What is redo log file mirroring?
  35. How to implement the multiple control files for an existing database?
  36. What is SGA? How it is different from Ver 6.0 and Ver 7.0?
  37. What is a Shared SQL pool?
  38. What is mean by Program Global Area (PGA)?
  39. List the factors that can affect the accuracy of the estimations?
  40. What are the different kind of export backups?

This entry was posted in Interview Questions. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *