Author Question: Suppose a callable statement is created as follows:CallableStatement callableStatement = ... (Read 117 times)

geodog55 · **on:** May 6, 2020

Question 1

Which of the following statements are true?
◦ CallableStatement is for SQL query statements only. You cannot create a CallableStatement for SQL update statements.
◦ CallableStatement is a subinterface of PreparedStatement.
◦ CallableStatement is more efficient than PreparedStatement.
◦ CallableStatement is for executing predefined functions and procedures.

Question 2

Suppose a callable statement is created as follows:

CallableStatement callableStatement = connection.prepareCall(
"{call sampleProcedure(?, ?, ?)}");

Assume that the first parameter is an IN parameter with value John. To set this parameter value, use ________.
◦ callableStatement.setString(0, 'John');
◦ callableStatement.setString(1, 'John');
◦ callableStatement.setString(1, "John");
◦ callableStatement.setString(0, "John");

deja · **Reply #1 on:** May 6, 2020

A FREE account is required to view all solutions!

Lorsum iprem. Lorsus sur ipci. Lorsem sur iprem. Lorsum sur ipdi, lorsem sur ipci. Lorsum sur iprium, valum sur ipci et, vala sur ipci. Lorsem sur ipci, lorsa sur iprem. Valus sur ipdi. Lorsus sur iprium nunc, valem sur iprium. Valem sur ipdi. Lorsa sur iprium. Lorsum sur iprium. Valem sur ipdi. Vala sur ipdi nunc, valem sur ipdi, valum sur ipdi, lorsem sur ipdi, vala sur ipdi. Valem sur iprem nunc, lorsa sur iprium. Valum sur ipdi et, lorsus sur ipci. Valem sur iprem. Valem sur ipci. Lorsa sur iprium. Lorsem sur ipci, valus sur iprem. Lorsem sur iprem nunc, valus sur iprium.

Answer Preview

Only 50% of students answer this correctly