최신 A2090-544 무료덤프 - IBM Assessment: DB2 9.7 Advanced DBA for LUW

A. Export data from the main partitioned table; drop the main partitioned table; create the main partitioned table with new partitioning range; import data into the main partitioned table.

B. Export data from the main partitioned table; create a table with the same definition as the partitioned table; attach to the main partitioned table; import data into the main partitioned table; run the SET INTEGRITY statement.

C. Create a table with the same definition as the partitioned table; attach to the main partitioned table; data will be automatically redistributed across all table partitions.

D. Create a table with the same definition as the partitioned table; load the new table with data; attach the new table to the main partitioned table; run the SET INTEGRITY statement.

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

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

C. It terminates immediately.

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

A. SYSCTRL

B. ACCESSCTRL

C. DATAACCESS

D. SQLADM

A. 6

B. 4

C. 1

D. 0

A. DB2_APM_PERFORMANCE

B. DB2_EXTENDED_IO_FEATURES

C. DB2_PARALLEL_IO

D. DB2_RESOURCE_POLICY

A. Use the REORG INDEX command.

B. Use the ALTER INDEX and REORG INDEX commands.

C. Use the DROP INDEX and CREATE INDEX commands.

D. Use the ALTER INDEX command.