1Z0-082 practice question 2 of 25

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

Full set: 142 questions
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 Correct answer
D: Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration Correct answer
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
Correct Answer:
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; F. Connect Time Failover requires the connect string to have two or more listener addresses configured
Explanation

Oracle Net Services provides several advanced features. Source routing, often used with Connection Manager (CMAN), allows a client connection to be routed through an intermediate destination, which is useful for traversing firewalls. Load balancing distributes client connections across multiple listeners or dispatchers (in a Shared Server setup) to optimize resource usage. Connect-time failover provides high availability by allowing a client to try another listener address from a configured list if the primary one is unavailable at the time of connection.

Why Incorrect

A. Connect-time failover and Transparent Application Failover (TAF) are separate features. Connect-time failover occurs at connection, while TAF handles failover of established sessions.
B. Source routing is configured in the client's tnsnames.ora file by specifying an address path; it does not require a name server like OID.
E. Client-side load balancing can be configured using a tnsnames.ora file with multiple addresses and does not strictly require a name server.

References

1. Oracle Database Net Services Administrator's Guide, 19c. Chapter 10, "Configuring Oracle Connection Manager". Explains using CMAN for firewall access via source routing.

2. Oracle Database Net Services Administrator's Guide, 19c. Chapter 8, "Configuring and Administering the Listener". Section "Listener Load Balancing of Connections to Dispatchers".

3. Oracle Database Net Services Administrator's Guide, 19c. Chapter 7, "Configuring Naming Methods". Section "Connect-Time Failover". States it enables clients to connect to another listener if the initial connection fails, requiring multiple listener addresses.

Scroll to Top