Oracle Database 12c: RAC Administration — Question 13

Examine this command:
$ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG
This three-Instance RAC database uses Flex ASM.
Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

Answer options

• A. It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.
• B. The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.
• C. The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.
• D. It is disabled because the -c1bgoal attribute is set to LONG.
• E. The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.

Correct answer: A, D

Explanation

The correct answer A is valid because the client must specify LOAD_BALANCE=YES in the TNS entry to enable server-side load balancing. Answer D is also correct since the -clbgoal attribute being set to LONG disables load balancing. Options B, C, and E are incorrect because they misrepresent the functionality of SCAN listeners in relation to load balancing in this context.