C2090-541問題集、IBM実際の試験問題

質問 1

Scheduled tasks are executed by the DB2 autonomic computing daemon (db2acd). Every five minutes the daemon checks for new or updated tasks. If a task is scheduled to run every five minutes and for some reason, the task takes seven minutes to complete, the daemon will not execute another instance of the task at the next 5 minute interval. Which minute mark will allow the next task to run?

A. 5

B. 10

C. 22

D. 17

正解: B

質問 2

You want to federate communication between two databases. What are two key requirements? (Choose two.)

A. Define nicknames for the tables of a federated server.

B. Use the JDBC Type 4 driver.

C. Enable the client for federation.

D. Enable the server for federation.

正解: A,D

質問 3

Which statement is correct about using the TAKEOVER HADR command?

A. The TAKEOVER HADR command can only be issued on the primary database and the primary database is connected to the standby database when the command is issued.

B. The TAKEOVER HADR command can only be issued on the standby database and the primary database is not connected to the standby database when the command is issued.

C. The TAKEOVER HADR command can only be issued to switch the roles of the primary and standby databases if the standby database is in local catchup state.

D. The TAKEOVER HADR command can only be issued to switch the roles of the primary and standby databases if the databases are in peer state.

正解: D

質問 4

Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF format.
Which command(s) can be used to do this?

A. EXPORT TO combined.ixf OF IXF SELECT * FROM table a INTERSECT SELECT * FROM table b

B. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a, table_b

C. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a: EXPORT APPEND TO combined.ixf OF IXF SELECT * FROM table_b;

D. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a UNION ALL SELECT * FROM table_b

正解: D

質問 5

Which HADR feature minimizes the impact of software maintenance on the Standby server?

A. Configure AUTOMATIC maintenance and perform a rolling upgrade

B. Configure all AUTOMATIC features.

C. Configure all AUTOMATIC maintenance parameters.

D. Configure AUTOMATIC maintenance and perform a roll forward.

正解: A

質問 6

You have a new table created with COMPRESS YES and a delimited ASCII file. You use the LOAD utility to load the data from the ASCII file into the table. When will all of the rows in the table be compressed?

A. after a table REORG

B. during the DELETE phase

C. after running INSPECT

D. during the BUILD phase

正解: A

質問 7

Which DB2 tool is a Java-based, generic XML parser which produces readable text output from the data generated by an event monitor?

A. db2evmonfrnt

B. db2xmlparser

C. db2eventfmt

D. db2evmonparser

正解: A

質問 8

You are running an IMPORT utility and have specified the option COMMITCOUNT AUTOMATIC Which two reasons will cause the IMPORT utility to COMMIT? (Choose two.)

A. to avoid lock escalation from row level to table level

B. to avoid running out of active log space

C. to avoid allocation of secondary log files

D. to avoid writing uncommitted data back to the database to make room in the buffer pool

正解: A,B

質問 9

When using table partitioning, which three operations are valid? (Choose three.)

A. DETACH partition

B. REORG all partitions

C. DROP partition

D. ATTACH partition

E. partition level REORG

正解: A,D,E

IBM DB2 9.7 DBA for Linux UNIX and Windows - C2090-541 模擬練習