nerdexam
Oracle

1Z0-058 · Question #113

From a command line, you can create an ASM volume with the same properties by using either SQL or ASMCMD. Which two commands will create a 500 MB volume called TESTVOL in the ACFSDG ACFS diskgroup…

The correct answer is A. SQL> alter diskgroup ACFSDG add volume TESTVOL size 500M unprotected; D. ASMCMD> volcreate -G ACFSDG -s 500M --redundancy unprotected TESTVOL. The ALTER DISKGROUP VOLUME SQL statements enable you to manage Oracle ADVM volumes, including the functionality to add, modify, resize, disable, enable, and drop volumes. You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device…

Administer ASM

Question

From a command line, you can create an ASM volume with the same properties by using either SQL or ASMCMD. Which two commands will create a 500 MB volume called TESTVOL in the ACFSDG ACFS diskgroup by storing only one copy of the volume file extents in the diskgroup

Options

  • ASQL> alter diskgroup ACFSDG add volume TESTVOL size 500M unprotected;
  • BASMCMD> volcreate -G ASMFS -s 500M
  • CSQL> alter diskgroup ACFS add volume TESTVOL size 500M;
  • DASMCMD> volcreate -G ACFSDG -s 500M --redundancy unprotected TESTVOL
  • ESQL> create volume TESTVOL diskgroup ACFSDG size 500M unprotected;

How the community answered

(14 responses)
  • A
    79% (11)
  • B
    7% (1)
  • C
    14% (2)

Explanation

The ALTER DISKGROUP VOLUME SQL statements enable you to manage Oracle ADVM volumes, including the functionality to add, modify, resize, disable, enable, and drop volumes. You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system. If the volume is hosting an Oracle ACFS file system, then you cannot resize that volume with the SQL ALTER DISKGROUP statement. Instead you must use the acfsutil size command. Creates an Oracle ADVM volume in the specified disk group. Syntax and Description volcreate -G diskgroup -s size [ --column number ] [ --width stripe_width ] [--redundancy {high|mirror|unprotected} ] Redundancy of the Oracle ADVM volume which can be specified for normal redundancy disk groups. The range of values is as follows: unprotected for non-mirrored redundancy, mirror for double-mirrored redundancy, or high for triple-mirrored redundancy. If redundancy is not specified, the setting defaults to the redundancy level of the disk group.

Topics

#ASM volumes#ACFS#volcreate#ASMCMD syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-058 Practice