IBM DB2 10.1 DBA for Linux, UNIX, and Windows

1.

Which of the following table types is NOT supported by the load utility?

A Temporal table A Range Partitioned table A Global Temporary table A Multidimensional Clustering table

2.

What does the FLUSH PACKAGE CACHE statement do?

It removes all dynamic SQL statements from the package cache. It removes only inactive SQL statements from the package cache. It saves dynamic SQL stored in the package cache to an external file. It causes all SQL statements in the package cache that are currently in use to be recompiled.

3.

Which statement about updating index statistics with the RUNSTATS command is true?

It requires a full index scan. It can be accomplished by sampling the index. It must be executed against all indexes for the table. It cannot be accomplished without scanning the associated table.

4.

What can be used to provide input to the Design Advisor?

An XML file. A query workload file. The database configuration file. The database manager configuration file.

5.

Which statement describes adaptive row compression?

Adaptive compression allows for use of customized compression dictionary creation algorithms. Adaptive compression maintains a dynamic and ever changing table-level row compression dictionary. Adaptive compression incorporates both classic table-level row compression and page-by-page based rowcompression. Adaptive compression incorporates four compression approaches: tablespace-level, table-level, page-level,and bufferpool-level.

6.

Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?

ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTER TABLESPACE my_ts REBALANCE;

ALTER TABLEPACE my_ts MANAGED BY DATABASE;ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTER TABLESPACE my_ts REBALANCE;

ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE STOGROUP sg_hot;ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2'; ALTER TABLESPACE my_ts REBALANCE;

ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot; ALTER STOGROUPsg_hot DROP '/db2/filesystem1', '/db2/filesystem2'; ALTER TABLESPACE my_ts REBALANCE;

7.

Which statement about range-clustered tables is true?

Range-clustered tables can be used with the REORG utility. Range-clustered tables can be used with multiple-column keys. Range-clustered tables can be used in a DB2 pureScale environment. Range-clustered tables can be used with value and default compression.

8.

Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?

db2pd db2dart db2look db2mimic

9.

You have just converted an existing database to an automatic storage database. What can you use to move data from an existing DMS table space to an automatic storage table space, while the data remains online and available for access?

The db2move command The db2relocatedb command

The ADMIN_MOVE_TABLE procedure

The ADMIN_MOVE_TABLE_UTIL procedure

10.

Which statement about the ADMIN_MOVE_TABLE procedure is true?

The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operationto the target table.

The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active (source) tableduring the move to a user-suppliedstaging table so they can be replayed against the target table when the move is complete.

If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target tablethat was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.

If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) tablewill be kept and if the target table isto be created automatically, a name that is different from that of the active table must be specified for the target table.

IBM DB2 10.1 DBA for Linux, UNIX, and Windows

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM DB2 10.1 DBA for Linux, UNIX, and Windows

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner