IBM DB2 11.1 DBA for LUW: C2090-600

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

C. CONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;

D. ATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

A. REORG TABLE sales INPLACE RESETDICTIONARY

B. REORG TABLE sales INPLACE REBUILDDICTIONARY

C. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

D. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

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.)

A. You can change the principal standby of the primary without first stopping HADR on the primary.

B. The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.

C. You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.

D. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.

E. 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.