000-731 training material

To become a 000-731 Professional, you need to complete all the test objectives. Study them with the use of IBM guide and then the test and evaluate your knowledge via our leading edge training resources.

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

The reasons for choosing us:

Quality & Value 000-731 training material
Our Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.