Oracle Database 12c: Installation and Administration — Question 31

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

Answer options

• A. It mounts databases and diskgroups to make ASM files available to database instances.
• B. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.
• C. It automatically places each disk from an external redundancy diskgroup in its own failure group.
• D. It divides files into extents and allows an extent to span disks.
• E. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.

Correct answer: B, E

Explanation

Option B is correct because ASM is designed to balance the I/O load by spreading files evenly across all disks in a diskgroup. Option E is also correct as it describes ASM's capability to mirror data at the allocation unit level. Options A, C, and D are incorrect as they do not accurately represent the primary functions of ASM.