Datasheet

Review Questions

16. How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has

already completed?

A. Issue the ALTER DISKGROUP … ADD DISK command.

B. Issue the ALTER DISKGROUP … UNDROP DISKS command.

C. Issue the ALTER DISKGROUP … DROP DISK CANCEL command.

D. Retrieve the disk from the Recycle Bin after the operation completes.

17. Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to

record the status of the operation?

A. ADD DIRECTORY

B. DROP DISK

C. RESIZE DISK

D. REBALANCE

E. ADD FAILGROUP

18. If you use ALTER DISKGROUP … ADD DISK and specify a wildcard for the discovery string,

what happens to disks that are already a part of the same or another disk group?

A. The command fails unless you specify the FORCE option.

B. The command fails unless you specify the REUSE option.

C. The command must be reissued with a more specific discovery string.

D. The other disks, already part of the disk group, are ignored.

19. You are an Oracle DBA responsible for an ASM instance. The disk controller on your system

fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the

controller and you don’t want to have to rebuild the disks from scratch. What do you do?

A. Take the whole disk group offline and wait for the controller card to be installed. Once

it’s installed, bring the disk group online again.

B. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that

you want to read from the non-failed disk. Once the disk controller is replaced, reset

the parameter to its original value.

C. You have no choice but to rebuild the disk. Drop the disk from the disk group and wait

for the controller to be replaced. Once the controller is replaced, add the disk back into

the disk group and allow ASM to rebuild it.

D. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group, you

will have to recover any data on that disk from a backup. The database will be unavail-

able until you can correct the problem and perform recovery.

E. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than

24 hours.

95134c01.indd 51 1/28/09 9:43:48 AM