Oracle Database Administration 2019 Certified Professional — Question 36

Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?

Answer options

• A. Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.
• B. Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.
• C. To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -failback attribute of a service to "Low, Medium, or High".
• D. Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance.

Correct answer: D

Explanation

The correct answer, D, accurately describes the mechanism of Dynamic Service Fallback, which allows services to return to their preferred instance once it is available. Option A incorrectly states that services can relocate to an available instance when stopped, which is not the focus of Dynamic Service Fallback. Option B discusses performance thresholds, which is not relevant to the fallback process. Option C misrepresents the configuration needed for Dynamic Service Fallback by introducing unnecessary performance levels.