nerdexam
Oracle

1Z0-034 · Question #5

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

The correct answer is A. ALTER DISKGROUP misc MOUNT; C. ALTER DISKGROUP misc CHECK ALL NOREPAIR. Altering Disk Groups You can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. Whenever possible, multiple operations in a single ALTERDISKGROUP statement are recommended. Grouping…

Managing Storage

Question

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

Options

  • AALTER DISKGROUP misc MOUNT;
  • BALTER DISKGROUP misc DROP DISK misc2;
  • CALTER DISKGROUP misc CHECK ALL NOREPAIR;
  • DALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
  • EALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

How the community answered

(44 responses)
  • A
    80% (35)
  • B
    7% (3)
  • D
    2% (1)
  • E
    11% (5)

Explanation

Altering Disk Groups You can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. Whenever possible, multiple operations in a single ALTERDISKGROUP statement are recommended. Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations. Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query theV$ASM_OPERATION view to monitor the status of this operation. Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk. Oracle ASM automatically rebalances the disk group as part of this operation. drop_disk_clause Use this clause to drop one or more disks from the disk group. The DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the disk group. When you drop a disk, Oracle ASM relocates all the data from the disk and clears the disk header so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCE keyword.

Topics

#ASM#disk group#rebalancing#ALTER DISKGROUP

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice