Oracle Database Administration 2019 Certified Professional — Question 59

Which three statements are true about Oracle ASM? (Choose three.)

Answer options

• A. An ASM instance must run on every node of a cluster.
• B. The SPFILE and password file for ASM are stored by default in an ASM disk group.
• C. It always requires a cluster to be installed and configured.
• D. A designated network is used for communication between ASM instances and their clients.
• E. ASM clients can fail over to other ASM instances.
• F. Only the maximum of three ASM instances are supported in a cluster.

Correct answer: B, D, E

Explanation

Option B is correct because the SPFILE and password file for ASM are indeed stored in an ASM disk group by default. Option D is accurate as a designated network facilitates communication between ASM instances and clients. Option E is true because ASM clients can seamlessly fail over to other ASM instances. Options A and C are incorrect as ASM does not require an instance on every node or the need for a cluster, and option F is false since there can be more than three ASM instances in a cluster.