Oracle Database 12c: Installation and Administration — Question 183

Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?

Answer options

• A. It cancels all pending disk drops within the disk group
• B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
• C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted
• D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
• E. It adds previously dropped disks back into the disk group

Correct answer: A

Explanation

The correct answer is A because the ALTER DISKGROUP dgroup1 UNDROP DISKS command is specifically designed to cancel any pending disk drops within the specified disk group. Options B, C, D, and E incorrectly imply that the command restores or mounts disks that have already been dropped, which is not the case.