ADV_JAVA_QUIZ2

Which method is used to retrieve the value of a column from the current row of a ResultSet?

• getColumnValue()

• getColumn()

• getInt(), getString()..etc

• getValue() 

Which of the following is used to call stored procedure?

• Statement

• PreparedStatement

• CalledStatement

• CallableStatment

Which of the following is method of JDBC batch process?

• setBatch()

• deleteBatch()

• removeBatch()

• addBatch()

In JDBC, what is the significance of the RowSet interface?

• It represents a single row from a result set.

• It is used to retrieve metadata about database tables.

• It provides a scrollable and updatable result set.

• It handles exceptions during SQL query execution.

What is the purpose of the COMMIT command in a transaction?

• To undo changes made during the transaction.

• To permanently save all changes made during the transaction.

• To initiate a new transaction.

• To terminate the current transaction without saving changes.

What is the role of the ROLLBACK command in a transaction? 

• To save changes permanently.

• To undo changes and return the database to its state before the transaction started.

• To initiate a new transaction.

• To terminate the current transaction.

Which of the following is NOT a characteristic of a Transaction? 

• Atomicity

• Consistency

•  Isolation

• Redundancy

What does setAutoCommit(false) do?

• commits transaction after each query

• explicitly commits transaction

• does not commit transaction automatically after each query
  

• never commits transaction

Which of the following is used to rollback a JDBC transaction?

• deleteTransaction()

• rollforward()

• rollback()

• RemoveTransaction()

Which of the following JDBC statement is correct?

• Statement st=con.createdStatement()

• PrepareStatement pst=con.preparedStatement()

• CallableStatement cst=con.CallableStatement()

• PreparedStatement pst=con.prepareStatement()