An administrator has deployed an application that uses 30 unique SQL statements with a maximum data
source connection pool size of 10.
What is the recommended prepared statement cache size for the application?

A.
10

B.
30

C.
40

D.
300

Explanation:
To determine the highest value for your cache size to avoid any cache discards, add the number of uniquely
prepared statements and callable statements, as determined by the SQL string, concurrency, and the scroll
type, for each application that uses this data source on a particular server. This value is the maximum number
of possible statements that can be cached on a given connection over the life of the server. Setting the cache
size to this value means that you never have cache discards. In general, configure a larger cache for
applications with a greater number of statements.
https://www.ibm.com/support/knowledgecenter/en/SSAW57_8.5.5/com.ibm.websphere.nd.doc/ae/
udat_jdbcdatasorprops.html