Oracle Database Administration 2019 Certified Professional — Question 74

Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

Answer options

• A. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
• B. When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.
• C. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
• D. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.

Correct answer: A

Explanation

The correct answer A accurately describes that clients sharing the same colocation_tag are directed to the same instance providing a specific service, optimizing resource usage. Option B misrepresents the routing priority by suggesting that a preferred instance can be overlooked, while C implies routing across preferred instances, which is not the main purpose. Option D incorrectly states that routing occurs only when a preferred instance is unavailable, which does not capture the primary function of colocation_tag.