大数据就业实战培训 Oracle就业实战培训
OCP 19c 1Z0-082认证考试题库（第3题）-CUUG内部学员版082题库解析
3.Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
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
Answer: CDF
Explanation:
Reference: https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
(解析：
sales.us.example.com=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-server)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-server)(PORT=1521)))
(CONNECT_DATA=
(SERVICE_NAME=sales.us.example.com)))
不能使用连接时故障转移或客户端负载平衡设置源路由。源路由按顺序连接到列表中的每个地址，而连接时间故障转移和客户端负载平衡则从列表中选择一个地址。
连接负载平衡特性通过平衡多个分派器之间的活动连接数来提高连接性能。在 OracleReal Application Clusters(Oracle RAC)环境中，连接池负载平衡还可以平衡多个实例之间的活动连接数。
In a shared server configuration, a listener selects a dispatcher in the following order:
1. Least loaded node.
2. Least loaded instance.
3. Least loaded dispatcher for that instance.
In a dedicated server configuration, a listener selects an instance in the following order:
1. Least loaded node.
2. Least loaded instance.
