Register Login
Internet / AI Technology University (ITU/AITU)
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:
What are the features of the Statement and PreparedStatement?

Using PreparedStatement,
JDBC "prepares" the SQL statement for execution by parsing, compiling, and building a query execution plan.



PreparedStatement supports batch processing but Statement does not.



PreparedStatement returns PreparedResultSet but Statement returns ResultSet.



The Statement is associated with the Connection object,
while the PreparedStatement is associated with the connection pool.



PreparedStatement is always more efficient than Statement even it is used once or twice per application lifetime.



The Statement is an interface while PreparedStatement is its implementation class.



PreparedStatement interface extends the Statement interface.



If run-time variables are used in the SQL,
the Statent created with this SQL is always unique for a database, and has to be recompiled each time.
PreparedStatement pushes non-changeable part of the SQL statement into the database and
compile it once for later bindings with run-time variables.



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!!!