> > >

JDBC MCQs

Consider the following statement:

PreparedStatement ps=con.prepareStatement("INSERT INTO ORDER (CUSTOMER_ID ,PRICE) VALUES(?,?)");

Which of the following should come after this statement?

ps.clearParameters(); <br>ps.setInt(1,3); <br>ps.setDouble(2,790.50); <br>ps.executeUpdate(sql); <br>

ps.clearParameters(); ps.setInt(1,3); ps.setDouble(2,790.50); ps.executeUpdate();

ps.clear(); ps.setInt(1,3); ps.setDouble(2,790.50); ps.executeUpdate(sql);

ps.clearParameters(); ps.setInt(1,3.09); ps.setDouble(2,790.50); ps.execute(sql);

ps.clearParameters(); ps.setDouble(2,790.50); ps.execute(sql);

Answer

Correct Answer: ps.clearParameters(); ps.setInt(1,3); ps.setDouble(2,790.50); ps.executeUpdate();

Explanation:

Note: This Question is unanswered, help us to find answer for this one

JDBC Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it