Examine these commands:
srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 –
tafpolicy preconnect
srvcl start service -db RACDB -service CRM
Instances RACDB_1 and RACDB_2 run on host0l and host02, respectively.
This is the only TNS entry in the client side tnsnames.ora:CRM =
(DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)
(ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521))
(ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521))
(CONNECT_DATA = (SERVICE_NAME = CRM)
(FAILOVER_MODE = (BACKUP=CRM_PRECONNECT)
(TYPE=SESSION)(METHOD=PRECONNECT))))
Which statement is true regarding the TAF settings?
A.
Clients using this configuration fail over and restart any active queries automatically.
B.
Clients using this configuration fail over and restart any active transactions automatically.
C.
This configuration will work only for a policy-managed RAC database.
D.
The configuration is incomplete because the TNS entry for the preconnected backup session is missing.
D
should be A
https://support.oracle.com/knowledge/Oracle%20Database%20Products/460982_1.html
Server side TAF settings override client-side counterparts that might be configured in TNS connect descriptors