Examine this command to create a volume in the DATA disk group:
SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH
STRIPE_WIDTH 1M;
STRIPE_COLUMNS 1;
The DATA disk group has 50GB free space.
Which two are prerequisites for successful execution of this command?
A.
COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
B.
The DATA disk group must not be created with external redundancy.
C.
The DATA disk group must not contain any other volume.
D.
The DATA disk group must have at least three failure groups.
E.
The DATA disk group must have an AU size of 1MB.
Explanation:
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group. A high redundancy disk group must
contain at least three failure groups. https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10072http://www.gratisexam.com/
https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm
A,D
https://docs.oracle.com/database/121/SQLRF/statements_1009.htm#BGBBAHJE
add_volume_clause
For size_clause, specify the size of the Oracle ADVM volume. The Oracle ASM instance determines whether sufficient space exists to create the volume. If sufficient space does not exist, then the Oracle ASM instance returns an error. If sufficient space does exist, then all nodes in the cluster with an Oracle ASM instance running and the disk group mounted are notified of the addition. Oracle ASM creates and enables on those nodes a volume device that can be used to create and mount file systems.
The following optional settings are also available:
In the redundancy_clause, specify the redundancy level of the Oracle ADVM volume. You can specify this clause only when creating a volume in a normal redundancy disk group. You can specify the following volume redundancy levels:
MIRROR: 2-way mirroring of the volume. This is the default.
HIGH: 3-way mirroring of the volume.
UNPROTECTED: No mirroring of the volume.
A and B
Agree, A and B