IBM DB2 9.7 Advanced DBA for LUW

1.

If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?

db2dart db2apptrk db2acsutil db2pd

2.

Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?

SORTHEAPTHRES 10000K, SORTHEAP 250K SORTHEAPTHRES 10000K SORTHEAP AUTOMATIC, SHEAPTHRES 10000K SORTHEAP AUTOMATIC, SHEAPTHRES 0

3.

Which action(s) will cause a compression dictionary to be removed from a table?

Set the table COMPRESS attribute to NO. Set the table COMPRESS attribute to NO;run REORG against the table. Set the table COMPRESS attribute to NO;run INSPECTESETDICTIONARY against the table. Set the table COMPRESS attribute to NO;run RUNSTATS against the table.

4.

Which statement is correct about statistical views?

A statistical view is created by executing runstats on a regular view. A statistical view holds information about the system catalog statistical tables. A statistical view provides the optimizer with additional correlation statistics. A statistical view provides the optimizer with more accurate cardinality estimates.

5.

A DBA migrating an existing database to DB2 9.7 wants to allow the primary and secondary recovery logs to be used with non-buffered IO. Which statement is true?

This behavior is automatically enabled by default.

The DB2_LOGGER_BUFFERED registry variable must be set to OFF.

The DB2_LOGGER_AUTO_BUFFERED registry variable must be set to YES.

The DB2_LOGGER_NON_BUFFERED_IO registry variable must be set to AUTO.

6.

What would indicate intra-partition parallelism in an Optimizer Plan?

BTQ LTQ IP DTQ

7.

When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?

It terminates immediately. It remains active as long as the MAXAGENTS setting is not exceeded. It is placed in the agent pool if the connection is terminated. It automatically releases the database connection and returns to the pool.

8.

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it. The index will automatically be compressed since the table it is associated with is compressed; the ALTERINDEX command does not have to be executed. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESSYES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary. The index will automatically be enabled for compression because the associated table is compressed;however, the index will not be compressed until it is REORGed.

9.

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?

CREATE UNIQUE INDEX xtab1 ON tab1 (c1);CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3, c4);

CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3, c4);

CREATE UNIQUE INDEX xtab1 ON tab1 (c4, c3, c2, c1);

CREATE UNIQUE INDEX xtab1 ON tab1 (c3) INCLUDE (c1, c2, c4);

10.

Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?

It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled.

It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set toAUTOMATIC, and if insufficient system memory problems are occurring.

It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too muchphysical memory. It is recommended that this variable be used to set the maximum percentage of memory that DB2 can useon the system.

IBM DB2 9.7 Advanced DBA for LUW

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 9.7 Advanced DBA for LUW

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