最新的IBM A2090-544免費考試真題

問題1

The DBA needs to create a table with key columns YEARMONTH and YEAR. This table needs to be partitioned by column YEARMONTH with three months per data partition. Additionally, data needs to be organized by column YEAR, so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

A. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (yearmonth))

B. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 12)
ORGANIZE BY DIMENSIONS (year))

C. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year))

D. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 12)
ORGANIZE BY DIMENSIONS (yearmonth))

正確答案: C

問題2

Which factor should influence your selection of distribution key(s)?

A. The distribution key(s) should include column(s) with the smallest number of distinct values.

B. The distribution key(s) should include the most frequently joined column(s).

C. The distribution key(s) should include the most frequently accessed XML column(s).

D. The distribution key(s) should include the longest column(s).

正確答案: B

問題3

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?

A. This behavior is automatically enabled by default.

B. The DB2_LOGGER_BUFFERED registry variable must be set to OFF.

C. The DB2_LOGGER_AUTO_BUFFERED registry variable must be set to YES.

D. The DB2_LOGGER_NON_BUFFERED_IO registry variable must be set to AUTO.

正確答案: A

問題4

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

A. RUNSTATS

B. IMPORT

C. INSPECT

D. LOAD

正確答案: A

問題5

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.

正確答案: B

問題6

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?

A. SORTHEAP AUTOMATIC, SHEAPTHRES 10000K

B. SORTHEAPTHRES 10000K

C. SORTHEAPTHRES 10000K, SORTHEAP 250K

D. SORTHEAP AUTOMATIC, SHEAPTHRES 0

正確答案: D

最新的IBM Assessment: DB2 9.7 Advanced DBA for LUW - A2090-544免費考試真題

聯系我們

站內鏈接

最新更新