While monitoring a JDBC data source’s performance during a test load, a system administrator
notices that there are a large number of prepared statements discarded from the cache. In order to
improve application throughput, how should the administrator tune the data source?

A.
Increase the size of the prepared statement cache until there are no statement discards under
load.

B.
Increase the maximum connection pool size and keep the prepared statement cache at its
default size.

C.
Set the connection pool purge policy to “EntirePool” and increase the maximum connection
pool size.

D.
Set the minimum connection pool size equal to the maximum connection pool size and keep
the prepared statement cache at its default size.

Explanation: