What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)

A. Table space available space

B. Table space read and write activity

C. Table space container assignments

D. Table level activity within a table space

E. Table space backup and recovery information

Which statement about dropped table recovery is correct?

A. Multiple dropped tables can be recovered with a single table space-level restore operation.

B. By default, the DROPPED TABLE RECOVERY option is off when a new table space is created.

C. The dropped table recovery feature lets you recover only dropped table data with a database- level restore operation.

D. For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.

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

CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (mnt/fsystem4 mnt/fsystem5

Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?

A. New storage containers can be added to it.

B. A different buffer pool can be associated with it.

C. A hard limit can be placed on the size to which its storage containers can grow.

D. Its high water mark can be lowered and its size can be reduced to the high water mark.

A storage group named HOT_SG was created as follows:

What does the DATA TAG 1 clause do?

A. It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.

B. It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be given preference over other objects when data access plans are generated.

C. It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.

D. It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this identifier can then be used when moving table spaces to and from the storage group, when dropping the storage group, or when commenting on the storage group.

What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?

A. Call the ADMIN_MOVE_TABLE procedure.

B. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.

C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.

D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.

Which statement about block indexes is correct?

A. Because of their large size, block indexes are extremely efficient.

B. Block indexes improve performance when data is not clustered on sequential pages.

C. Prefetching of data pages relies on sequential detection when block indexes are used.

D. The records for each block are retrieved using a mini-relational scan of saved data pages.

When defining storage groups for multi-temperature data, storage paths are usually grouped according to their quality of service characteristics. What are three common quality of service characteristics used?

A. Frequency of access; acceptable access time; volatility of the data.

B. Acceptable access time; redundancy of the data; volatility of the data.

C. TIR (table/index data ratio); frequency of access; volatility of the data;

D. Frequency of access; redundancy of the data; acceptable access time;

If the following commands complete successfully for a single partition database: CREATE DATABASE mydb;

CREATE BUFFERPOOL mybp; Which statement is true?

A. Self tuning is enabled for the MYBP buffer pool.

B. The initial size for the MYBP buffer pool is zero pages.

C. The database has to be restarted before the MYBP buffer pool will become active.

D. The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL statement.

Which statement about DB2 Merge Backup is FALSE?

A. It can be used to merge offline backups to build full offline table space backups.

B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.

C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.

D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.

With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?

A. The primary database only.

B. The auxiliary standby database only.

C. The principal standby database only.

D. The primary, auxiliary standby, and principal standby database.