40 Best DB2 Interview Questions and Answers

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

DB2 Interview Questions and Answers List

  1. What is DB2 (IBM Database 2)?
  2. What is an access path?
  3. What is an alias?
  4. Explain what a plan is?
  5. What is a DB2 bind?
  6. What information is used as input to the bind process?
  7. What is meant by the attachment facility?
  8. What is meant by AUTO COMMIT?
  9. What is a base table?
  10. What is the function of buffer manager?
  11. What is a buffer pool?
  12. How many buffer pools are there in DB2?
  13. On the create tablespace, what does the CLOSE parameter do?
  14. What is a clustering index?
  15. What will the COMMIT accomplish?
  16. What is meant by concurrency?
  17. What is cursor stability?
  18. What is the function of the Data Manager?
  19. What is a Database Request Module(DBRM)?
  20. What is a data page?
  21. What are data types?
  22. What is Declaration Generator(DCLGEN)?
  23. What does DSNDB07 database do?
  24. What will the FREE command do to a plan?
  25. What is a host variable?
  26. What will the DB2 optimizer do?
  27. What is a page?
  28. What is pagespace?
  29. What is a predicate?
  30. What is a Resource Control Table(RCT)? Describe its characteristics.
  31. What is meant by repeatable read?
  32. Describe what a storage group(STOGROUP) is?
  33. How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
  34. What is the format (internal layout) of “TIMESTAMP”?
  35. What is meant by a unit of recovery?
  36. Can DASD types assigned to storage groups be intermixed(i.e., 3350s and 3380s)?
  37. What are the three types of page locks that can be held?
  38. Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
  39. How are write I/Os from the buffer pool executed?
  40. What is a DB2 catalog?

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

Leave a Reply

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