C2090-614 Online Practice Questions and Answers

The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log):

MESSAGE:

ADM5502W

The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful. Which two database configuration parameter settings should be checked? (Choose two.)

A. LOCKLIST

B. MAXAPPLS

C. MAXLOCKS

D. MAXAGENTS

E. LOCKTIMEOUT

Which statement about compression dictionaries is FALSE?

A. Page-level dictionaries are stored in hidden rows within the table.

B. Table-level dictionaries are stored in hidden rows within the table.

C. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.

D. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

What is the recommended method for removing old backup images and log files for a DB2 10.1 database?

A. Manually delete old backups and logs.

B. Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.

C. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.

D. Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before generating a new backup.

In which situation would you NOT use a redirected restore?

A. To redefine the paths of a defined storage group.

B. To move table space containers onto different physical devices.

C. To restore a backup image from one operating system to another.

D. To restore a backup image to a target machine that is different from the source machine.

A table named SALES was created as follows:

Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first quarter of 2013 to the SALES table and leave the table accessible?

A. ALTER TABLE sales ADD PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;

B. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') FROM TABLE q12013_sales;

C. ALTER TABLE sales ADD PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5; SET INTEGRITY FOR sales IMMEDIATE CHECKED;

D. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') FROM TABLE q12013_sales; SET INTEGRITY FOR sales IMMEDIATE CHECKED;

Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?

A. One composite block index and one unique index.

B. One composite clustering index and one dimension block index.

C. One index that serves as both the dimension block index and the composite block index.

D. One index that serves as both the dimension block index and the composite clustering index.

To configure instance-level auditing with db2audit, which authority is required?

A. SYSADM

B. SYSCTRL

C. SECADM

D. SYSMAINT

What can be done to prevent applications from failing when DB2 cannot create a new log file?

A. Set MAX_LOG to 0

B. Set LOGBUFSZ to -1

C. Set LOGSECOND to -1

D. Set BLK_LOG_DSK_FUL to YES

Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?

A. logarchopt1

B. failarchpath

C. mirrorlogpath

D. overflowlogpath

In which situation would you NOT use a redirected restore?

A. To redefine the paths of a defined storage group.

B. To move table space containers onto different physical devices.

C. To restore a backup image from one operating system to another.

D. To restore a backup image to a target machine that is different from the source machine.