Consider the server pools configured in the following scenario. There are no servers in the cluster,
and all server pools are empty.
When server1 joins the cluster, it will be assigned to ____________.
A.
sp1
B.
sp2
C.
sp2 and sp2_1
D.
sp2 and sp2_2
E.
sp2, ap2_1, and sp2_2
F.
sp3
Explanation:
https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD91116
C>>>>>
For example, assume that there are no servers in a cluster; all server pools are empty.
When a server, named server1, joins the cluster:
Server-to-pool assignment commences.
Oracle Clusterware only processes top-level server pools (those that have no parent server pools), first. In this example, the top-level server pools are sp1, sp2, and sp3.
Oracle Clusterware lists the server pools in order of IMPORTANCE, as follows: sp2, sp3, sp1.
Oracle Clusterware assigns server1 to sp2 because sp2 has the highest IMPORTANCE value and its MIN_SIZE value has not yet been met.
Oracle Clusterware processes the remaining two server pools, sp2_1 and sp2_2. The sizes of both server pools are below the value of the MIN_SIZE attribute (both server pools are empty and have MIN_SIZE values of 1).
Oracle Clusterware lists the two remaining pools in order of IMPORTANCE, as follows: sp2_1, sp2_2.
Oracle Clusterware assigns server1 to sp2_1 but cannot assign server1 to sp2_2 because sp2_1 is configured to be exclusive with sp2_2.
After processing, the cluster configuration appears, as follows
Table 3-3 Post Processing Server Pool Configuration
Server Pool Name Assigned Servers
sp1
sp2 server1
sp3
sp2_1 server1
sp2_2