IBM 000-544 問題集

質問 1：
A user with Security Administrator (SECADM) authority executes the following statements:

If user USER2 queries the table S.TAB1, how many rows will be returned?
A. 0
B. 2
C. 3
D. 1
正解：B

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

質問 3：
A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?
A. Configuration Advisor
B. Partition Assistant
C. Design Advisor
D. Workload Manager
正解：C

質問 4：
Given a database with Self-Tuning Memory Manager (STMM) enabled, what will DB2 do when a new buffer pool is created using the IMMEDIATE option?
A. Attempt to create the buffer pool and immediately request additional instance level memory. If the instance level memory is not available, then creation of the buffer pool is deferred until the database is stopped and restarted.
B. Attempt to create the buffer pool and immediately request additional memory from the operating system to allocate. If the operating system memory is not available, the buffer pool will not be created.
C. Attempt to create the buffer pool and immediately allocate the memory requested from available database shared memory. If the memory available is not sufficient, then allocation of the buffer pool will be deferred until the database is stopped and restarted.
D. Attempt to create the buffer pool and immediately allocate the memory requested, resizing the existing buffer pools and heaps as required. If there is insufficient memory in the global memory allocation for DB2, the buffer pool will not be created.
正解：C

質問 5：
If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?
A. Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.
B. Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.
C. Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.
D. Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.
正解：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：
A database and a table space were created using the following commands:

Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert the database?
A. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
C. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
正解：B

質問 8：
Which of the following techniques will ensure that you CANNOT encounter two active primary servers in an HADR pair?
A. Use a virtual IP Address in the CATALOG DATABASE command.
B. Use a virtual IP Address for both servers.
C. Catalog both servers separately and use a fixed IP address for both servers.
D. Set ALTERNATER SERVER to fixed IP Addresses on both servers.
正解：A

質問 9：
Which action can be performed by the ALTER TABLESPACE statement?
A. Change an SMS table space to a DMS table space on any database partition.
B. Change the size of a container in an SMS table space.
C. Add a container to an SMS table space on a database partition that currently has no containers.
D. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.
正解：C