QUESTION: 25

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

The PAGESIZE database configuration parameter is set to 32K.
The AUTO_REORG database configuration parameter is set to NO.
The DFT_EXTENT_SZ database configuration parameter is set to 8.
The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
The INTRA_PARALLEL database manager configuration parameter is set to NO.

Answer(s): D,E

Reveal Solution Next Question

QUESTION: 26

Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

Creating, using, or altering thresholds
Granting, altering, or revoking workload privileges
Using or altering the default service classes and workloads
Creating service classes, service subclasses, and workloads
Creating, activating, stopping or dropping workload management event monitors

Answer(s): B,D

Reference:

ftp://ftp.software.ibm.com/ps/products/db2/info/vr101/pdf/en_US/DB2WorkloadMgmnt-db2wlme1011.pdf (page 23)

Reveal Solution Next Question

QUESTION: 27

Which of the following are all valid types of trigger?

AFTER, ATOMIC, BEFORE
AFTER, ATOMIC, INSTEAD OF
AFTER, BEFORE, INSTEAD OF
ATOMIC, BEFORE, INSTEAD OF

Answer(s): C

Reference:

https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0020224.html

Reveal Solution Next Question

QUESTION: 28

The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)

You can change the principal standby of the primary without first stopping HADR on the primary.
The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.
You can remove the primary database from the target list of a standby although the standby is connected to the primary.
You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.
You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary’s target list.

Answer(s): A,E

Reference:

https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ha.doc/doc/c0059996.html

Reveal Solution Next Question

Free C2090-600 Exam Braindumps (page: 7)

QUESTION: 25

QUESTION: 26

Reference:

QUESTION: 27

Reference:

QUESTION: 28

Reference: