最新のC2090-546問題集で試験を準備する

IBM C2090-546 試験概要:

IBM C2090-546 試験シラバストピック:

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 認定 C2090-546 試験問題：

1. The SAMPLE database is backed up and the recovery logs are included in the backup image. Which of the following actions is required to restore the database to the end of the backup?

A) RECOVER DB sample TO END OF BACKUP;
ROLLFORWARD DB sample AND COMPLETE;
B) RESTORE DB sample;
ROLLFORWARD DB sample TO END OF BACKUP AND COMPLETE;
C) RESTORE DB sample TO END OF BACKUP AND STOP;
D) RECOVER DB sample TO END OF BACKUP;

2. A table named TAB_A has a primary key and 2 additional indexes that were created by the DBA. If the ADMIN_MOVE_TABLE procedure is used to MOVE table TAB_A from a table space named TS4K to a table space named TS16K, how many indexes will be on the table after the procedure finishes running?

A) 2
B) 1
C) 0
D) 3

3. What is the correct setting for the DIAGSIZE database manager configuration parameter to limit the total size of the db2diag.log and <instance>.nfy files to 60 MB and use 10 rotating files for db2diag.log and 10 for <instance>.nfy?

A) DIAGSIZE=10,60
B) DIAGSIZE=60
C) DIAGSIZE=60,10
D) DIAGSIZE=6

4. Which two workload management thresholds support priority aging by providing a remapping action? (Choose two.)

A) SQLROWSREADINSC
B) CPUTIMEINSC
C) REMAPACTIVITY
D) ACTIVITYTOTALTIME
E) CONCURRENTDBCOORDACTIVITIES

5. Index INDEX1 has been created as follows: CREATE INDEX index1 ON table_x (cola) Which of the following actions can be done through an ALTER INDEX statement?

A) Change the PCTFREE specification.
B) Make the COMPRESS attribute YES or NO.
C) Add a column to the index key.
D) Make this index the clustering index.

質問と回答：