IBM C2090-544 問題集

質問 1：
Which command CANNOT be used to create the compression dictionary for a table?
A. IMPORT
B. LOAD
C. RUNSTATS
D. INSPECT
正解：C

質問 2：
Given the following table spaces, their associated page size, and number of pages:

Which sets of buffer pools will ensure that all of the data in the table spaces will be fit into memory for optimal data access?
A. BP1 - 4K page size, 30000 pages BP2 - 8K page size, 20000 pages BP3 - 16K page size, 15000 pages
B. BP1 - page size 8K, 45000 pages
C. IBMDEFAULTBP - 16K page size, 85000 pages
D. IBMDEFAULTBP - 4K page size, 25000 pages BP1 -16K page size, 20000 pages
正解：A

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

質問 4：
What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?
A. Issue a RESTORE DATABASE command with the ROLLFORWARD option;
issue a SET TABLESPACE CONTAINERS command;
issue a RESTORE DATABASE command with the CONTINUE option;
B. Issue a RESTORE DATABASE command with the ROLLFORWARD option;
issue a RESTORE DATABASE command with the CONTINUE option;
C. Issue a RESTORE DATABASE command with the REDIRECT option;
issue a RESTORE DATABASE command with the CONTINUE option;
D. Issue a RESTORE DATABASE command with the REDIRECT option;
issue a SET TABLESPACE CONTAINERS command;
issue a RESTORE DATABASE command with the CONTINUE option;
正解：D

質問 5：
While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client:
CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000;
CATALOG DATABASE samp001 AS samp001 AT NODE node001;
TERMINATE;
When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node.
The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?
A. Add a Database Connection Services entry to the /etc/services file on the Windows client.
B. Match the port number in the CATALOG TCPIP NODE command with the port number in the /etc/services file on the remote server.
C. Add an entry into the Database Connection Services directory on the Windows client.
D. Change the service name (SVCENAME) in the remote servers database configuration.
正解：D

質問 6：
A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list?
A. UPDATE DBM CFG USING NUM_INITAGENTS 0;
db2stop;
db2start;
B. UPDATE DBM CFG USING NUM_POOLAGENTS 200;
db2stop;
db2start;
C. UPDATE DBM CFG USING NUM_INITAGENTS 200;
db2stop;
db2start;
D. UPDATE DBM CFG USING NUM_POOLAGENTS 0;
db2stop;
db2start;
正解：B

質問 7：
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 accessed XML column(s).
C. The distribution key(s) should include the longest column(s).
D. The distribution key(s) should include the most frequently joined column(s).
正解：D