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


rleezy04

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Excellent

 

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

More than 50% of American adults have oral herpes, which is commonly known as "cold sores" or "fever blisters." The herpes virus can be active on the skin surface without showing any signs or causing any symptoms.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

For a complete list of videos, visit our video library