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 questionsOracle 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.
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.
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.
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
- Question 10Which three statements are true about the Oracle Data Dictionary? (Choose three.)
