000-731考試題庫由51-pass專業IT認證講師及產品專家精心打造，包括了當前最新的全真試題，全部附有正確答案。
51-Pass 承諾“考試失敗、全額退費”。我們保證您一次性通過000-731 考試。只要您購買了我們的《000-731 Exam》考題首次考試失敗，憑蓋有PROMETRIC或VUE考試中心鋼印的考試成績單，我們將退還您購買000-731題庫的全部費用。
Exam Number/Code: 000-731
Exam Name: DB2 9 DBA for Linux,UNIX and Windows
Questions and Answers: 138Q&As
Updated：5-28-2010
1.A database administrator has HADR enabled and wants to do a LOAD WITH COPY NO option on the primary server. What happens on the standby server?
A.The Load is replicated without problems.
B.The Load will stop with an appropriate error message.
C.The Load will be automatically converted to NONRECOVERABLE and the standby database will be marked bad.
D.The Load will be automatically converted to COPY YES if the directory or device specified on the primary server is accessible for the standby database.
Correct:C
2.A DBA needs to set the DIAGLEVEL configuration parameter to 4 while users are connected to the database. How can this change be implemented in a way that has a minimum impact to the environment?
A.Quiesce the database and update the parameter.
B.Attach to the instance and update the parameter.
C.Connect to the database in a single user mode and update the parameter.
D.Attach to the instance, update the parameter, stop and restart the instance.
Correct:B
3.A transaction that receives a log disk full error (SQL0968C) will fail and be rolled back. In order to prevent the roll back, which of the following should be done?
A.Set BLK_LOG_DSK_FUL to NO
B.Set BLK_LOG_DSK_FUL to YES
C.Decrease space for the active log directory
D.Reduce the LOGPRIMARY, LOGSECOND and LOGFILSIZ
Correct:B
4.Recovering a single table space to a point in time:
A.requires archive log files from the last restorable backup.
B.is not possible, table spaces must be recovered to end of logs.
C.is not possible if the disks for that table space are not recoverable.
來源：(http://blog.sina.com.cn/s/blog_520a8fa40100js4v.html) - 最新的IBM認證000-731題庫下載！_killtest_新浪博客
D.requires the sysadmin to connect to the target database prior to issuing the command.
Correct:A
5.As part of a high availability takeover strategy using HADR, the LOG INDEX BUILD table attribute for the APPLICANT table is set to OFF. What is the most likely effect of this change?
A.After failover, the APPLICANT table index may be rebuilt.
B.An attempt to create a unique index on the APPLICANT table will fail.
C.Index builds for the APPLICANT table on the primary system will take longer.
D.The LOGINDEXBUILD database configuration parameter overrides the table attribute.
Correct:A
6.A FINANCE database must be available 24 hours a day, seven days a week. Which of the following commands can be issued to back up the FINANCE database, while minimizing the impact on other database users?
A.BACKUP DATABASE finance ONLINE TO COMPRESS
B.BACKUP DATABASE finance TO UTIL_IMPACT_PRIORITY 5
C.BACKUP DATABASE finance ONLINE TO UTIL_IMPACT_PRIORITY 15
D.BACKUP DATABASE finance ONLINE TO UTIL_IMPACT_PRIORITY 100
Correct:C
7.A recovery of database DB1 is started by issuing RECOVER DATABASE DB1 TO END OF LOGS. The recovery fails during the rollforward phase. In order to continue the recovery from the point of failure, which of the following commands should be executed?
A.RECOVER DATABASE DB1 RESTART
B.RECOVER DATABASE DB1 TO END OF LOGS
C.RECOVER DATABASE DB1 TO END OF LOGS RESTART
D.RECOVER DATABASE DB1 CONTINUE TO END OF LOGS
Correct:B
8.Which of the following is used to protect a database from the accidental deletion of an active log file and data corruption of log files caused by hardware failure?
A.newlogpath
B.failarchpath
C.mirrorlogpath
D.overflowlogpath
Correct:C
51-pass題庫網為妳提供更多最新最全的題庫下載！
