最新的DB2認證 A2090-544考試題庫

問題1

When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?

A. It terminates immediately.

B. It is placed in the agent pool if the connection is terminated.

C. It remains active as long as the MAXAGENTS setting is not exceeded.

D. It automatically releases the database connection and returns to the pool.

正確答案: B

問題2

Table T1 was created by executing the following statement:

Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that inserted 100,000 rows into table T1. The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming current statics exist for the table and index, which index will provide optimal performance for this query?

A. CREATE INDEX idx1 ON t1 (deptno, empno)

B. CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)

C. CREATE INDEX idx1 ON t1 (deptno, empno) INCLUDE (deptname)

D. CREATE INDEX idx1 ON t1 (deptno)

正確答案: A

問題3

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_PARALLEL_IO

B. DB2_EXTENDED_IO_FEATURES

C. DB2_RESOURCE_POLICY

D. DB2_APM_PERFORMANCE

正確答案: A

問題4

Which series of items are required to establish a TCP/IP connection to a DB2 for z/OS database from a DB2 for Linux, UNIX, or Windows server?

A. hostname, port number/protocol, target database name, local database name, node name

B. hostname, logical unit (LU) name, target database name, local database name, node name

C. hostname, port number/protocol, subsystem ID, local database name, node name

D. hostname, logical unit (LU) name, subsystem ID, local database name, node name

正確答案: A

問題5

A database named MYDB was created by executing the following command: CREATE DATABASE mydb AUTOMATIC STORAGE NO Later, a decision is made to modify this database so that both it and its table spaces use automatic storage. What steps are required to make this modification?

A. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing DMS table spaces.

B. Use the ALTER DATABASE command to convert the database; all existing table spaces will be converted automatically.

C. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing table spaces.

D. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing SMS table spaces.

正確答案: A

問題6

A journaling application inserts data with continually increasing sequential keys while a clean up process randomly deletes erroneous rows. What can be done to maximize insert performance?

A. Issue an ALTER TABLESPACE EXTEND statement.

B. Issue an ALTER TABLE APPEND ON statement.

C. Issue a db2set DB2MAXFSCRSEARCH=1024 command.

D. Issue a db2set DB2SKIPDELETED=ON command.

正確答案: B

問題7

Which conditions must be met to implement HADR?

A. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).

B. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

C. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

D. Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).

正確答案: A

問題8

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

問題9

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. Workload Manager

B. Design Advisor

C. Configuration Advisor

D. Partition Assistant

正確答案: B

問題10

In order for HADR to start, which statement is true when setting the HADR_TIMEOUT database configuration value?

A. Changes to the HADR_TIMEOUT value will take effect immediately.

B. If the HADR_TIMEOUT value is different between the two servers, the lowest value is used.

C. If the HADR_TIMEOUT value is set to -1, connection timeouts will not occur.

D. The HADR_TIMEOUT value must be identical on both the primary and the standby server.

正確答案: D

最新的IBM Assessment: DB2 9.7 Advanced DBA for LUW - A2090-544免費考試真題

最新更新

站內鏈接

聯系我們