The SELF_TUNING_MEM database configuration (db cfg) parameter is set to
ON. Which three statements will cause the memory tuner to actively tune memory within the
database? (Choose three.)
A.
One db cfg parameter is set to AUTOMATIC or the size of at least one buffer pool is set to
AUTOMATIC, and the DAT ABAS E_M E M O R Y db cfg parameter is set to a numeric value or to
AUTOMATIC
B.
Any two of LOCKLIST, SHEAPTHRES_SHR, PCKCACHESZ are set to AUTOMATIC
C.
The SORTHEAP db cfg parameter is set to AUTOMATIC
D.
At least one buffer pool has its size set to AUTOMATIC
E.
MAXLOCKS is set to AUTOMATIC