This topic contains a solution. Click here to go to the answer

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

geodog55

  • Hero Member
  • *****
  • Posts: 530

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");


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by geodog55 on May 6, 2020

deja

  • Sr. Member
  • ****
  • Posts: 332
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




geodog55

  • Member
  • Posts: 530
Reply 2 on: May 6, 2020
Thanks for the timely response, appreciate it


lindahyatt42

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

For a complete list of videos, visit our video library