最新なIBM C2090-541問題集（104題）、真実試験の問題を全部にカバー！

質問 1：
Due to an application error, some data was deleted from a very large table residing in table space TS1. The table space was then renamed TS2 before the error was detected. Rather than try and rebuild this table, it was decided that database DB1 would be restored and then rolled forward to a point-in-time (PIT) before the delete operation took place. Unfortunately the PiT roll forward was done to a time that was too early and some critical transactions were missing when the database was brought back on-line. Which steps must be taken to ensure that the critical transactions which are currently missing from the database are correctly applied to the database and that table space TS1 is renamed TS2?
A. 1. Restore table space TS1 from the DB1 backup image.
2.Roll forward to the correct point-in-time.
3.Rename table space TS1 to TS2.
4.Re-run the batch processes.
B. 1. Restore table space TS1 from the DB1 backup image.
2. Roll forward to end of logs.
C. 1. Restore database DB1.
2.Roll forward to the correct point-in-time.
3.Rename TS1 to TS2.
D. 1, Restore database DB1
2. Roll forward to end of logs.
正解：C

質問 2：
Which privilege will allow a user to extract AUDIT data into delimited files for analysis?
A. AU DI T_D E LI M_EXT R AC T
B. EXECUTE
C. CREATE AUDIT
D. AUDIT
正解：B

質問 3：
What are two valid protocols that can be used with the CATALOG NODE command to establish communication with a server named SERVER1? (Choose two.)
A. token ring
B. named pipe
C. IPv6
D. NetBIOS
正解：B,C

質問 4：
Click the Exhibit button.

Refer to the logging configuration parameters shown in the exhibit.
If the active log path was only configured to have enough space for 100 active log files, what will happen if there are currently 100 active log files and DB2 needs to create active log file 101?
A. The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log space and active log path are both full. The transaction will be rolled back andit's associated application will be forced off.
B. The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log path is full. The transaction will be rolled back andit's associated application will be forced off.
C. The database will appear to be hung because the BLK_LOG_DSK_FUL configuration parameter is set to YES. Once some active log files arearchived,the database will resume normal operation.
D. The database will continue normal operation because infinite logging has been enabled and any logs that will not fit in the active log path will automatically be created within the OVERFLOWLOGPATH until logs in the active log path begin to be archived.
正解：C

質問 5：
Which list of automatic maintenance parameters can have a policy defined to specify their automatic behavior?
A. AUTO_RUNSTATS, AUTO_STMT_STATS, AUTO_DB_BACKUP
B. AUTO_RUNSTATS, AUTO_REORG, AUT0_STMT_STATS
C. AUTO_DB_BACKUP, AUTO_RUNSTATS, AUTO_REORG
D. AUTO_STMT_STATS, AUTO_DB_BACKUP, AUTO_RUNSTATS, AUTO_REORG
正解：C

質問 6：
The event monitor for transactions has been replaced in DB2 9.7 with which tool?
A. db2top
B. MON_GET_WORKLOAD table function
C. MON_GET_ACTIVITY_DETAILS table function
D. db2evmonfmt
正解：B

質問 7：
Which method may be used to collect deadlock information in DB2 97?
A. DB2_CAPTURE_LOCKTIMEOUT registry variable
B. DB2DETA1LDEADLOCK event monitor
C. LOCKING event monitor
D. DEADLOCKS event monitor
正解：C

質問 8：
You have a UTIL_IMPACT_LIM of 50 and a UTIL_IMPACT_PRIORITY of 60 for the backup utility. What are the maximum amount of system resources that the backup utility can use?
A. 50%
B. 60%
C. 40%
D. 30%
正解：D