A Java application will be deployed, and you must configure a RAC database to support highly available connections.
The application will use the Universal Connection Pool (UCP), and Fast Connection Failover (FCF) must be enabled.
Which two statements are true? (Choose two.)
A.
The application may use the JDBC thin driver.
B.
The ons.jar file must be present in the CLASSPATH.
C.
The ONS daemon must be started on the middle tier running the Java application.
D.
You must configure TAF, either on the client or for the service.
E.
The ONS daemon must be started on the middle tier and client machines to enable FCF.
B. For using Oracle RAC Fast Application Notification, the ons.jar file must be present in the CLASSPATH or an Oracle Notification Services (ONS) client must be installed and running in the client system.
C. if UCP and FCF are enabled, your Java program automatically becomes an ONS subscriber without having to manage FAN events directly.
Agree,
Correct B,C
I was wondering about A, JDBC thin and JDBC OCI drivers are supporter so the application could could use JDBC driver…
but thinking a little bit I guess this will be on application scope…
Performance
Which is faster, the Thin driver or the OCI driver?
As always, it depends. There are some applications where the the Thin driver is faster, some where the OCI driver is faster. As of 10.1.0, the Thin driver is probably slightly faster than the OCI driver. In cases when the client and server are the same type of hardware and OS, the OCI driver puts a little less load on the RDBMS, even though the Thin client is faster. The differences are usually small, less than 10%. Most of our customers use the Thin driver because of its easier administration. Your mileage may vary.
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#35_01
Correct A,C
A: D81259GC10 9-21, Both JDBC thin and JDBC OCI drivers are supported.
Not B: the sentence JAG posted says “or”, so ONS client on client system can let you not have ons.jar on CLASSPATH.
Correct: B and C
https://docs.oracle.com/cd/E11882_01/java.112/e16548/apxracfan.htm#JJDBC28936
Following Student Guide D81250Gc11, it says:
Option A is right: “This Automatic connection management results from FAN events received by the local ONS daemon, or by a remote ONS if a local one is not used, and is handled by a special event handler thread. Both JDBC thin and JDBC OCI drivers are supported”
Option B is right: “For using Oracle RAC Fast Application Notification Services, the ons.jar file must be present in the CLASSPATH …”
Option C and E are wrong: “Note: With Oracle Database 10g Release 2 and later, there is no requirement to use ONS daemons on the mid-tier when using Oracle Universal Connection Pool.”