IBM 000-544 問題集

質問 1：
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

質問 2：
Click the Exhibit button.

In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node.
Explanation:
The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?
A. CATALOG DCS DATABASE dsample AS db2t
B. CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS
C. CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS
D. CATALOG DCS DATABASE db2t AS dsample
正解：A

質問 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. 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.
B. 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.
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. 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.
正解：D

質問 4：
What is required to successfully use the check backup utility (db2ckbkp)?
A. read permission on the backup image
B. read permission on the database
C. system maintenance authority
D. system administrator authority
正解：A

質問 5：
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 and C3 together, which statement(s) will create index(es) that will provide optimal query performance?
A. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3);
B. CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3);
C. CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3);
D. CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1);
正解：A

質問 6：
Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?
A. It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too much physical memory.
B. It is recommended that this variable be used to set the maximum percentage of memory that DB2 can use on the system.
C. 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.
D. It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled.
正解：C

質問 7：
A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a Saturday prior to the full backup being taken.
What is the fastest way to restore the database?
A. RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Monday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
B. RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
C. RESTORE DB proddb TAKEN AT (Friday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Saturday);
D. RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
正解：D

質問 8：
What would indicate intra-partition parallelism in an Optimizer Plan?
A. DTQ
B. IP
C. BTQ
D. LTQ
正解：D

質問 9：
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_NON_BUFFERED_IO registry variable must be set to AUTO.
C. The DB2_LOGGER_AUTO_BUFFERED registry variable must be set to YES.
D. The DB2_LOGGER_BUFFERED registry variable must be set to OFF.
正解：A