Lookup

Created by info@itofthefuture.com

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

Read the question and choose the best answer. 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:
According to the code below, what does cstmt.executeBatch() return?

CallableStatement cstmt = con.prepareCall(
			"{call updatePrices(?, ?)}");
cstmt.setString(1, "Colombian");
cstmt.setFloat(2, 8.49f);
cstmt.addBatch();

cstmt.setString(1, "Colombian_Decaf");
cstmt.setFloat(2, 9.49f);
cstmt.addBatch();

??? = cstmt.executeBatch();

Array of Objects. Actual class of returned objects is database vendor specific.

void

Array of int error codes for each statement in the batch

Null as updatePrices stored procedure doesnt return a ResultSet

Array of int - update counts for each batch commands

Number of rows that were affected by the batch query

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