Oracle Database 12c: RAC Administration — Question 33

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?

Answer options

• 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.

Correct answer: A, D

Explanation

The correct answer A is essential because the compatibility settings must support volume creation, which is only possible if they are set to 11.2 or higher. Option D is also correct since having at least three failure groups is a requirement for certain redundancy types. Options B, C, and E are incorrect as they do not apply to the prerequisites for creating a volume in this context.