IBM A2090-544 問題集

質問 1：
What is a method for enabling non-buffered I/O at the table space level in a DB2 database?
A. Set the DB2_FILESYSTEM_CACHE configuration parameter to YES.
B. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER TABLESPACE command.
C. Use the USE DIRECT IO clause with the CREATE TABLESPACE or ALTER TABLESPACE command.
D. Set the DB2_DIRECT_IO configuration parameter to YES.
正解：B

質問 2：
The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This table needs to be partitioned by column YEARDAY with three months per data partition. Additionally, data needs to be organized 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
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (day))
B. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day))
C. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day))
D. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year))
正解：D

質問 3：
A DBA wants to migrate a DB2 LUW 8.2.2 database to version 9.7 and plans to use currently committed (CC) semantics on an application-by-application basis. Which process will yield the desired results?
A. Set the DB2_USE_CC_SEMANTICS registry variable to APPLICATION, then migrate the database.
B. Migrate the database, then assign the value ON to the CURR_COMMIT configuration parameter.
C. Migrate the database, then assign the value AVAILABLE to the CURR_COMMIT configuration parameter.
D. Set the DB2_USE_CC_SEMANTICS registry variable to YES, then migrate the database.
正解：C

質問 4：
Which statement about compression and temporary tables is NOT correct?
A. The minimum size that a table must be before compression is used is larger for temporary tables than for regular tables.
B. The explain facility and the db2pd utility can be used to determine whether a temporary table has been compressed.
C. Compression is only applied to created temporary tables that were defined with the CREATE TEMPORARY TABLE ?COMPRESS YES statement.
D. When executing queries that require temporary tables, DB2 considers the storage savings and the impact to query performance to determine whether compression is worthwhile.
正解：C

質問 5：
If LOGSECOND=-1 then which of the following statements is true?
A. You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path.
B. The database will reserve active log space for transactions that may need to roll back and write log records.
C. You must configure the OVERFLOWLOGPATH configuration parameter if your active log path is not on a raw device.
D. An infinite number of overflow log files will be used with archival logging.
正解：A

質問 6：
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?
A. db2apptrk
B. db2dart
C. db2pd
D. db2acsutil
正解：C

質問 7：
An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
1 server1 0
2 server1 1
3 server1 2
4 server1 3
The following command is issued to add a new database partition:
db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4
Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?
A. DB2 responds to the configuration change by stopping all partitions.
B. All partitions are active but partition 5 is not available until a temporary table space is defined.
C. Partitions 1, 2, 3, 4, and 5 are active and available.
D. Partitions 1, 2, 3, and 4 are active, but partition 5 is not.
正解：D