Oracle Database Administration 2019 Certified Professional — Question 75

Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)

Answer options

• A. Client-side connect time load balancing works only if it uses a tnsnames entry specifying LOAD_BALANCE=yes.
• B. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
• C. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
• D. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
• E. In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.

Correct answer: B, D

Explanation

Option B is correct because server-side connect time load balancing occurs when the initial connection is established. Option D is also correct as client-side load balancing is performed at the initial connection attempt. Options A and C are incorrect because A misrepresents client-side load balancing requirements, and C inaccurately describes how server-side load balancing distributes connections.