You are asked by the DBA team leader to consolidate three different Oracle databases, which supported three separate workloads, into one large three-instance RAC database on a three-node cluster.
You also need to create a separate service to represent each workload type and support client-side load balancing.
The CRM service has two preferred instances, the HR service has two, and the ORDERS service has only one. Any instance may be used as an available instance for any service that is not specified as a preferred service for that same instance. You decide to create three separate entries in TNSNAMES.ORA.
Choose three options describing the number of entries you would have in each address list. (Choose three.)
A.
three entries in the address list for the HR service for the listeners on all three nodes
B.
three entries in the address list for the CRM service for the listeners on all three nodes
C.
three entries in the address list for the ORDERS service pointing to the listeners on all three nodes
D.
two entries for the address list for the HR service for the listeners on the nodes containing the preferred instances for HR
E.
one entry for the address list for the ORDERS service for the listeners on the nodes containing the preferred instance for ORDERS
F.
two entries for the address list for the CRM service pointing to the listeners on the nodes containing the preferred instances for CRM