Choose three correct statements about ASM disk group attributes set from the ASMCA Create
Disk Group
A.
The field labeled ASM Compatibility sets the compatible.asm attribute.
B.
When creating a disk group with ASMCA, the default setting for the ASM Compatibility field
(compatible.asm) is 10.1.
C.
The Database Compatibility field (compatible.rdbms) sets the minimum version level for any
database instance that is allowed to mount the disk group.
D.
To use ADVM volumes, ADVM Compatibility (compatible.advm) must be set to 11.2.0 or later
and ASM Compatibility must be 11.2.0 or later.
E.
Advancing the values for disk group compatibility attributes can be reversed if desired.
Explanation:
COMPATIBLE.ASM
The value for the disk group COMPATIBLE.ASM attribute determines the minimum software
version for an Oracle ASM instance that can use the disk group.
COMPATIBLE.RDBMS
The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum
COMPATIBLE database initialization parameter setting for any database instance that is allowed
to use the disk group.
COMPATIBLE.ADVM
The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group
can contain Oracle ASM volumes. The value must be set to 11.2 or higher.
Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher
The default disk group compatibility settings are 11.2 for Oracle ASM compatibility, 10.1 for
database compatibility, and no value for Oracle ADVM compatibility. The disk group compatibility
settings can only be advanced; you cannot revert to a lower compatibility setting.
Oracle Database Storage Administrator’s Guide
A is right.
B is wrong. default 11.2 for compatible.asm. for compatible.rdbms default is 10.1
C is right
D is right. 11.2 + is required for ADVM
E is wrong. you can only advancing the value
So A.C.D. are correct
C is wrong. Specifies the minimum software version required for a database instance to use files in this disk group