Register Login
Internet / AI Technology University (ITU/AITU)
Created by info@itofthefuture.com
Welcome Anonimous.User to this quiz related to Test Java And Databases.

Read the question and choose the best answer. Time is limited to 40 seconds!

Important! Do not forget to rank the quality of the question (from bad to excellent).
An initiator of the quiz will get royalty score for QnAs created by her/him and can win the Top Creativity Prize.
Question:
Sometimes we need to do multiple database changes at once. What is the right way to accelerate processing and execute multiple JDBC statements at once?

Use addBatch() method for each SQL statement and executeBatch() method for running the batch query.

      

Statement stmt = conn.createStatement();
stmt.addBatch("INSERT INTO Employees (Id, Name) VALUES(9517,Jane)");
stmt.addBatch("INSERT INTO Employees (Id, Name) VALUES(9518,Betty)");
stmt.executeBatch();



Use PreparedStatement to collect multiple statements for a single execution.

      

PreparedStatement stmt = conn.createStatement();
stmt.collect("INSERT INTO Employees (Id, Name) VALUES(:0,:1)");
stmt.collect("INSERT INTO Employees (Id, Name) VALUES(:2,:3)");
stmt.execute();



Separate statements by semicolon and use one of execute... methods

  

Statement stmt = conn.createStatement();
stmt.executeUpdate("INSERT INTO Employees (Id, Name) VALUES(9517,Jane);"+
"INSERT INTO Employees (Id, Name) VALUES(9518,Betty)");



Collect multiple statements in the list and use PreparedStatement for execution.

      

PreparedStatement stmt = conn.createStatement();
ArrayList listOfStatements = new ArrayList();
listOfStatements.add("INSERT INTO Employees (Id, Name) VALUES(:0,:1)");
listOfStatements.add("INSERT INTO Employees (Id, Name) VALUES(:2,:3)");
....
stmt.execute(listOfStatements);



Using Transactions we can accelerate performance of multiple statements



Rank the Quality of the Question from "-10" (bad) or "0" (not clear) to 10 (correct) or even 20 (very good!)
-10 (bad/wrong) 0 (not clear) 10 (correct) 20 (very good!)
Your summary report will be available to you and your instructor. Thank you for your work!!!