A2090-544 Online Practice Questions and Answers

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?

A. 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.

B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.

C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES 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.

D. 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.

What is the minimum authority required to execute the LOAD command?

A. DATAACCESS

B. SQLADM

C. ACCESSCTRL

D. SYSCTRL

What is a method for enabling non-buffered I/O at the table space level in a DB2 database?

A. Set the DB2_DIRECT_IO configuration parameter to YES.

B. Set the DB2_FILESYSTEM_CACHE configuration parameter to YES.

C. Use the USE DIRECT IO clause with the CREATE TABLESPACE or ALTER TABLESPACE command.

D. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER TABLESPACE command.

What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data?

A. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Check constraint integrity for the partitioned table

B. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Rebind the partitioned table

C. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Update statistics on the partitioned table

D. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Reorg the partitioned table

Which conditions must be met to implement HADR?

A. Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).

B. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

C. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).

In order for HADR to start, which statement is true when setting the HADR_TIMEOUT database configuration value?

A. The HADR_TIMEOUT value must be identical on both the primary and the standby server.

B. Changes to the HADR_TIMEOUT value will take effect immediately.

C. If the HADR_TIMEOUT value is set to -1, connection timeouts will not occur.

D. If the HADR_TIMEOUT value is different between the two servers, the lowest value is used.

Which command CANNOT be used to create the compression dictionary for a table?

A. IMPORT

B. INSPECT

C. LOAD

D. RUNSTATS

Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?

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

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

C. It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too much physical memory.

D. It is recommended that this variable be used to set the maximum percentage of memory that DB2 can use on the system.

Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?

A. The ADMINGETTABCOMPRESSINFO table function.

B. The ADMINGETTABCOMPRESSINFO_V97 table function.

C. The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.

D. The ADMIN_GET_TAB_INFO table function.

Which data organization schemes are supported?

A. PARTITION BY HASH and ORGANIZE BY

B. PARTITION BY RANGE and ORGANIZE BY HASH

C. PARTITION BY HASH and ORGANIZE BY RANGE

D. PARTITION BY RANGE and ORGANIZE BY