C2090-614 Online Practice Questions and Answers

What will occur when a database administrator adds a new automatic storage path to an existing storage group?

A. New table spaces will start consuming storage on the new path.

B. Existing table spaces will not consume storage on the new path.

C. The storage group will be placed in "Rebalance Pending" mode.

D. DB2 will verify that space is available on the storage path specified.

Where is the HADR_TARGET_LIST configuration parameter set?

A. On the primary database only.

B. On all participating databases.

C. On the tertiary standby databases.

D. On the auxiliary standby databases only.

What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?

A. AUDIT

B. VALIDATE

C. EXECUTE

D. CONTEXT

What is the preferred method for reclaiming unused storage in a DMS table space?

A. Perform an ALTER TABLESPACE...REDUCE operation.

B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.

C. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.

D. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.

Which statement about partitioned indexes is FALSE?

A. Both system- and user-generated indexes can be partitioned.

B. Each index partition contains references only to data in its corresponding data partition.

C. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition

D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.

Which statement about Insert-Time-Clustered (ITC) is correct?

A. Views cannot be created on ITC tables.

B. ITC tables do not support row compression.

C. Block indexes cannot be created for ITC tables.

D. ITC tables can release their empty pages to the operating system.

Which command(s) should be used to drop database partition 10 from a database named MYDB?

A. STOP DBM DROP DBPARTITIONNUM 10; DROP DBPARTITIONNUM VERIFY;

B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10;

C. CONNECT TO mydb; DROP DBPARTITIONNUM 10; CONNECT RESET;

D. CONNECT TO mydb; DROP DBPARTITIONNUM 10; ACTIVATE DB mydb;

The following statement was used to create a table space named TBSP1 in a non-partitioned database:

Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?

A. ALTER TABLESPACE tbsp1 REDUCE MAX

B. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK

C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

D. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;

You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?

A. The INSPECT utility

B. The db2pd command

C. The db2dart command

D. The database recovery history file

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.