Lookup

Created by info@itofthefuture.com

Welcome Anonimous.User to this quiz related to Test Java And Databases.

Read the question and choose correct answers. Time is limited to 40 seconds!

Important! Do not forget to rank the quality of the question (from bad to excellent).
An initiator of the quiz will get royalty score for QnAs created by her/him and can win the Top Creativity Prize.

Question:
Select true statements related to usage of prepared statements with a connection pool

Since JDBC 3.0 the data source layer is now responsible for caching prepared statements.
So, existing code (pre-JDBC 3.0) running under JDBC 3.0 will automatically leverage PreperedStatement pooling

Prepared statements introduce significant overhead but used with a connection pool
they will improve performance even if executed just once over their lifetime

PreparedStatement objects are cached per a JDBC connection

Using PreparedStatement objects under JDBC 3.0 you have full control over which prepared statements are cached and pooled

PreparedStatement objects used in a connection pool will improve performance
only with special code options introduced by JDBC 3.0

Since JDBC2.0 PreparedStatement objects are automatically cached per a connection pool but not per a JDBC connection

Rank the Quality of the Question from "-10" (bad) or "0" (not clear) to 10 (correct) or even 20 (very good!)
-10 (bad/wrong) 0 (not clear) 10 (correct) 20 (very good!)

Your summary report will be available to you and your instructor. Thank you for your work!!!