Oracle Database Administration 2019 Certified Professional — Question 50

Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)

Answer options

• A. Services support the balancing of client connections across RAC database instances.
• B. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
• C. Load balancing can be done by the client or the listener, but not both, for any one connection request.
• D. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
• E. Load balancing can be done by the client, the listener, or both, for any one connection request.

Correct answer: A, D, E

Explanation

Option A is correct because services do indeed help in distributing client connections across RAC instances. Option D is right as client-side load balancing can effectively balance requests among SCAN listeners. Option E is also accurate since load balancing can be performed by either the client, the listener, or both. However, option B is incorrect because the node listener does not redirect clients in that manner, and option C is wrong as it implies that only one entity can perform load balancing at a time, which is not the case.