A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?

• A. BACKUP DATABASE payroll USE MIRROR
• B. BACKUP DATABASE payroll USE FU\SHCOPY
• C. BACKUP DATABASE payroll USE SNAPSHOT
• D. BACKUP DATABASE payroll USE XBSA

A file named db2advise.in contains the text shown below:
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?

• A. Executes the first SOL statement in the workload file 100 times.
• B. Executes an index analysis for the first SQL statement in the workload file 100 times.
• C. Executes up to 100 combinations of optimizations for both SQL statements in the workload file
• D. Executes both SQL statements in the workload file 100 times.

Click the Exhibit button.

Refer to the logging configuration parameters shown in the exhibit.
If the active log path was only configured to have enough space for 100 active log files, what will happen if there are currently 100 active log files and DB2 needs to create active log file 101?

• A. The database will appear to be hung because the BLK_LOG_DSK_FUL configuration parameter is set to YES. Once some active log files arearchived,the database will resume normal operation.
• B. The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log space and active log path are both full. The transaction will be rolled back andit's associated application will be forced off.
• C. The database will continue normal operation because infinite logging has been enabled and any logs that will not fit in the active log path will automatically be created within the OVERFLOWLOGPATH until logs in the active log path begin to be archived.
• D. The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log path is full. The transaction will be rolled back andit's associated application will be forced off.

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

Which set of procedures will be required to perform a rolling upgrade in a HADR environment?

• A. 1. Upgrade the system where the standby database resides.
  2.Issue the TAKEOVER HADR command on the primary database server.
  3.Upgrade the original primary database.
  4.Return to the original configuration by switching the roles of the primary and standby databases.
• B. 1. Upgrade the system where the standby database resides.
  2.Issue the TAKEOVER HADR command on the standby database server.
  3.Upgrade the original primary database.
  4.Return to the original configuration by switching the roles of the primary and standby databases.
• C. 1. Upgrade the system where the primary database resides.
  2.Issue the TAKEOVER HADR command on the primary database server.
  3.Upgrade the new primary database.
  4.Return to the original configuration by switching the roles of the primary and standby databases.
• D. 1. Upgrade the system where the primary database resides.
  2.Issue the TAKEOVER HADR command on the primary database server.
  3.Upgrade the original primary database.
  4.Return to the original configuration by switching the roles of the primary and standby databases.