最新的IBM认证000-731题库下载！

DB2 考试题库由我们专业IT认证讲师及产品专家精心打造，包括了当前最新的全真试题，全部附有正确答案。

KillTest实行“一次不过全额退款”承诺。

题库根据考试厂商的动态变化而更新，在厂家考题每次对考题做出修改或变题后，我们会在第一时间更新题库，确保覆盖率始终在96%以上！

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.

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

为你提供更多最新最全的题库下载！