Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
Source Routing enables the use of Connection Manager (CMAN) which allows for routing network traffic through a firewall, enabling secure connections. Load Balancing can indeed distribute the number of connections among dispatchers within a Shared Server configuration, optimizing resource utilization. Connect Time Failover requires the connect string to have two or more listener addresses configured to provide an alternative in case the initial connection attempt fails.
I think C, D and F are correct.
D seems a legit answer.. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9
C, D & F
Correct Answer : C,D and F
A & C & F is correct answer
A is wrong… Connect-Time Failover is a feature of local naming method, and can be easily set up by adding a tns entry into tnsnames. ora file on the client machine, then the client can connect to the second database (listener) if the first database (listener) cannot be connected
A is wrong. Connect-Time Failover involves not yet connected sessions to failover a different address in case the first attempt is unreacheble. Transparent Application Failover involves sessions already connected in the database, to failover to the next address when the session is terminated. Pretty similar, but not dependent. You can have a configuration with ConnectTime Failover but not Transparent Application Failover
ama, Please suggest suitable answer
C, D, F
D is incorrect. Standalone Oracle databases perform load balancing by distributing connections among the shared server dispatcher processes. Check out https://docs.oracle.com/en/database/oracle/oracle-database/19/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9
A. Connect Time Failover requires the use of Transparent Application Failover (TAF) --> False B. Source Routing requires the use of a name server --> False, IP address are also accepted. C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall --> True D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration --> True E. Load Balancing requires the use of a name server --> False, IP address are also accepted. F. Connect Time Failover requires the connect string to have two or more listener addresses configured. --> True
CDF is right!!!
BCF is right
A. Connect Time Failover requires the use of Transparent Application Failover (TAF): Connect Time Failover allows Oracle Net to automatically fail over to another Oracle Database instance if the initial connection attempt fails. TAF enhances this feature by preserving the client-side session state during a failover. D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration: Load Balancing in Oracle Net distributes connection requests across multiple dispatchers to optimize resource utilization in a Shared Server (or MTS) configuration. F. Connect Time Failover requires the connect string to have two or more listener addresses configured: Connect Time Failover requires multiple listener addresses specified in the connect string to provide failover capability. If one listener is unavailable, Oracle Net attempts to connect to the next listener in the list. https://bitly.cx/ExamsTopics