nerdexam
Oracle

1Z0-062 · Question #92

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

The correct answer is A. It cancels all pending disk drops within the disk group. undrop_disk_clause Use this clause to cancel the drop of disks from the disk group. You can cancel the pending drop of all the disks in one or more disk groups (by specifyingdiskgroup_name) or of all the disks in all disk groups (by specifying ALL). This clause is not relevant…

Managing Database Storage Structures

Question

Examine the following ALTER command:

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

Options

  • AIt cancels all pending disk drops within the disk group.
  • BIt restores disks that are being dropped as the result of a DROP DISKGROUP operation
  • CIt mounts disks in the disk group for which the drop-disk operation has already been co pleted
  • DIt restores all the dropped disks in the disk group for which the drop-disk operation has already been
  • EIt adds previously dropped disks back into the disk group

How the community answered

(53 responses)
  • A
    92% (49)
  • C
    2% (1)
  • D
    4% (2)
  • E
    2% (1)

Explanation

undrop_disk_clause Use this clause to cancel the drop of disks from the disk group. You can cancel the pending drop of all the disks in one or more disk groups (by specifyingdiskgroup_name) or of all the disks in all disk groups (by specifying ALL). This clause is not relevant for disks that have already been completely dropped from the disk group or for disk groups that have been completely dropped. This clause results in a long-running operation. You can see the status of the operation by querying the V$ASM_OPERATION dynamic performance view. Undropping a Disk from a Disk Group: Example To cancel the drop of disks from a disk group, dgroup_01, issue the following statement: ALTER DISKGROUP dgroup_01

Topics

#ASM diskgroup#ALTER DISKGROUP#disk management#storage administration

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice