Multiple choice technology databases

Your application demands frequent connection and disconnection from the database. You have three listener processes those are listening for the database PROD. While settings up connect string using Oracle Enterprise Manager 10g Database Control, which two options would you select to balance the connection load across all the listener process? (Choose two)

  1. Use only the first address.

  2. Try one address selected at random.

  3. Try each address, in order, until one succeeds.

  4. Try each address, randomly, until one succeeds.
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

To balance load across multiple listeners, you can either randomly select one address (TRY ONE ADDRESS SELECTED AT RANDOM) or try addresses randomly until one succeeds (TRY EACH ADDRESS, RANDOMLY, UNTIL ONE SUCCEEDS). Using only the first address sends all traffic to one listener. Trying addresses in order is sequential failover, not load balancing.

AI explanation

Oracle's client-side load balancing works by having the client pick one address to try (ADDRESS_LIST with LOAD_BALANCE=on), either trying just one address at random per connection or trying addresses in a random order until one succeeds — both are documented load-balancing behaviors when connecting through multiple listeners. Trying them 'in order' (not randomly) describes failover behavior, not load balancing, which is why that option isn't selected.

Keep practicing — related questions