最新のC2090-544問題集で試験を準備する

IBM C2090-544 試験概要:

IBM C2090-544 試験シラバストピック:

IBM DB2 9.7 Advanced DBA for LUW 認定 C2090-544 試験問題：

1. If LOGSECOND=-1 then which of the following statements is true?

A) The database will reserve active log space for transactions that may need to roll back and write log records.
B) You must configure the OVERFLOWLOGPATH configuration parameter if your active log path is not on a raw device.
C) An infinite number of overflow log files will be used with archival logging.
D) You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path.

2. Which method should be used to construct an LBAC security component that represents a person's level of trust?

A) TREE
B) SET
C) ORDER
D) ARRAY

3. 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) 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) 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 with the CREATE INDEX statement that is used to create it.
D) 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.

4. If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?

A) DB2_EXTENDED_IO_FEATURES
B) DB2_APM_PERFORMANCE
C) DB2_RESOURCE_POLICY
D) DB2_PARALLEL_IO

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

A) IMPORT
B) RUNSTATS
C) INSPECT
D) LOAD

質問と回答：