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:
Assume we have a stored procedure with this signature:

  MultiSP (IN I1 INTEGER, OUT O1 INTEGER, INOUT IO1 INTEGER)

Is it possible to obtain 2 output parameters via JDBC?

No, JDBC doesnt support INOUT parameters in stored procedures

JDBC supports only one output parameter in stored procedures

Use registerOutParameter() and getInt() methods of the CallableStatement interface

Organize loop using nextOutParameter() method of the CallableStatement interface

Use getInt() method of the CallableStatement interface to get the first integer and
the getIntOut() method to get the second parameter.

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