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 clientside 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 vailable 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