Oracle Database Administration I — Question 36

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Answer options

• A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
• B. Source Routing requires the use of a name server
• C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
• D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
• E. Load Balancing requires the use of a name server
• F. Connect Time Failover requires the connect string to have two or more listener addresses configured

Correct answer: C, D, F

Explanation

Option C is correct as Source Routing indeed allows the use of Connection Manager to facilitate routing through firewalls. Option D is accurate because Load Balancing can manage connections to dispatchers in a Shared Server setup. Option F is also true since Connect Time Failover requires multiple listener addresses in the connect string. Options A, B, and E are incorrect because they do not reflect the requirements for the respective features accurately.