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 83 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
Wow, this really help


komodo7

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

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?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

For a complete list of videos, visit our video library