Practice questions

• Question 1: Which command can be used to display only the instance level registry settings for an instance db2inst1?
  1. db2set -all db2inst1
  2. db2set -i db2inst1
  3. db2set -lr
  4. db2val

• Question 2: Which of the following commands can be used to retrieve CURRENT and PENDING values of database manager configuration parameters for the instance db2inst1? (Choose two.)
  1. db2look -dbmcfg
  2. db2 "ATTACH TO db2inst1"; db2 "GET DBM CFG SHOW DETAIL"
  3. db2 "GET DBM CFG SHOW DETAIL"
  4. db2pd -dbmcfg
  5. db2greg
• Question 3: Which of the following table functions displays the registry setting?
  1. MON_GET_DATABASE ()
  2. MON_GET_INSTANCE ()
  3. ENV_GET_REG_VARIABLES ()
  4. MON_GET_UTILITY()
• Question 4: Which of the following parameters contributes to DATABASE_MEMORY usage? (Choose two.)
  1. dbheap
  2. stmtheap
  3. applheapsz
  4. appl_memory
  5. util_heap_sz
• Question 5: What is the order...