JDBC Quiz # 5

You have to handle an erroneous situation in a transaction. Which method comes handy in this case?

con.commit(false);

con.commit();

con.rollback();

con.revertback();

con.rollback(true); 

Which type of statement object will you use to execute a stored procedure?

Statement

PreparedStatement

CallableStatement

StoredStatement

Stat

Which of the following methods eliminates the need to call wasNull() method to handle null database fields?

getObject();

getInt();

getString();

getFloat();

getNull(); 

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