DB2 10 for z/OS Database Administrator Free Practice Exam Questions

52 real DB2 10 for z/OS Database Administrator exam questions with answers and AI explanations. IBM certification prep — page 3 of 6.

1. Question 21: When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
2. Question 22: When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
3. Question 23: Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)
4. Question 25: On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?
5. Question 26: How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?
6. Question 27: What does dsmtop use to gather metrics?
7. Question 28: What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?
8. Question 31: Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?
9. Question 32: Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?
10. Question 33: Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)