A2090-544無料問題集「IBM Assessment: DB2 9.7 Advanced DBA for LUW」

質問 1

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 解答を投票する

質問 2

Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?

（A）LOAD_HEAP_SZ and STAT_HEAP_SZ

（B）LOAD_HEAP_SZ and DATABASE_MEMORY

（C）UTIL_HEAP_SZ and DATABASE_MEMORY

（D）UTIL_HEAP_SZ and STAT_HEAP_SZ

正解：C 解答を投票する

質問 3

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）3

（B）1

（C）2

（D）0

正解：C 解答を投票する

質問 4

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_EXTENDED_IO_FEATURES

（B）DB2_PARALLEL_IO

（C）DB2_APM_PERFORMANCE

（D）DB2_RESOURCE_POLICY

正解：B 解答を投票する

質問 5

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 a db2set DB2SKIPDELETED=ON command.

（B）Issue a db2set DB2MAXFSCRSEARCH=1024 command.

（C）Issue an ALTER TABLESPACE EXTEND statement.

（D）Issue an ALTER TABLE APPEND ON statement.

正解：D 解答を投票する

質問 6

Which command CANNOT be used to explicitly build a compression dictionary for a table?

（A）REORG

（B）LOAD

（C）IMPORT

（D）INSPECT

正解：C 解答を投票する

質問 7

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

（A）It is placed in the agent pool if the connection is terminated.

（B）It automatically releases the database connection and returns to the pool.

（C）It terminates immediately.

（D）It remains active as long as the MAXAGENTS setting is not exceeded.

正解：A 解答を投票する

質問 8

How can you change an existing non-partitioned index for a partitioned table to a partitioned index?

（A）Use the ALTER INDEX and REORG INDEX commands.

（B）Use the ALTER INDEX command.

（C）Use the REORG INDEX command.

（D）Use the DROP INDEX and CREATE INDEX commands.

正解：D 解答を投票する

質問 9

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, subsystem ID, local database name, node name

（B）hostname, logical unit (LU) name, subsystem ID, local database name, node name

（C）hostname, port number/protocol, target database name, local database name, node name

（D）hostname, logical unit (LU) name, target database name, local database name, node name

正解：C 解答を投票する

A2090-544 無料問題集「IBM Assessment: DB2 9.7 Advanced DBA for LUW」

弊社を連絡する

関連リンク

トップ試験