Online Access Free A2090-541 Exam Questions

Which two can be replicated using HADR? (Choose two.)

• A.database configuration changes
• B.CREATE TABLE... NOT LOGGED INITIALLY operations
• C.LOAD operations
• D.Data Definition Language (DDL) statements

Which feature introduced in DB2 9.7 allows faster roll-in and roll-out of data partitions?

• A.autorunstats for partitioned tables
• B.individual indexes for each partition in a partitioned table
• C.autorunstats for each partition in a partitioned table
• D.global index for partitioned tables

When are packages automatically rebound?

• A.When inoperative packages are executed.
• B.When invalid packages are executed.
• C.When the DB2_AUTO_REBIND configuration parameter is set to ENABLED
• D.When the DB2_AUTO_REBIND registry variable is set to YES.

You are unable to configure a data source using DB2 Discovery. What are three reasons why this is happening? (Choose three.)

• A.The DISCOVERJNST parameter is enabled.
• B.The database has not been cataloged.
• C.The DISCOVER_DB parameter is disabled.
• D.The database does not exist.
• E.A network failure exists between the control center client and the database

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 dbcfg 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.MAXLOCKS is set to AUTOMATIC.
• C.Any two of LOCKLIST, SHEAPTHRES_SHR,PCKCACHESZ are set to AUTOMATIC.
• D.The SORTHEAP db cfg parameter is set to AUTOMATI
• E.At least one buffer pool has its size set to AUTOMATIC.