IBM Assessment DB2 10.1 DBA for Linux, UNIX, and Windows Set 1

1.

Which statement is correct for a user who holds SECADM authority?

A user who holds SECADM authority can only grant and revoke database object privileges. A user who holds SECADM authority can grant and revoke all database level authorities and databaseobject privileges. A user who holds SECADM authority can only grant and revoke DBADM and SECADM database levelauthorities. A user who holds SECADM authority can only grant and revoke label based access control (LBAC) securitylabels.

2.

Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?

INGEST REPLICATION LOAD WITH READ ACCESS IMPORT WITH BUFFERED INSERT

3.

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.

4.

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.

5.

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.

6.

Which statement describes a way to minimize the impact of a RUNSTATS operation?

Reduce I/O by using a shadow table space for statistics collection. Execute the RUNSTATS command with the WITH DISTRIBUTION option specified. Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified. Limit the number of pages and rows processed by using page-level or row-level table sampling.

7.

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.

8.

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.

9.

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

10.

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

IBM Assessment DB2 10.1 DBA for Linux, UNIX, and Windows Set 1

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 Assessment DB2 10.1 DBA for Linux, UNIX, and Windows Set 1

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