Quiz for Transactions

Q1: What is a transaction in JDBC?

A. A process of writing SQL queries B. A set of SQL statements that execute randomly C. A group of operations treated as a single unit D. An HTTP request to a database

Q2: Which method is used to commit a transaction?

A. execute() B. commit() C. complete() D. apply()

Q3: What is the default auto-commit behavior in JDBC?

A. Auto-commit is off B. Auto-commit is on C. Depends on the driver D. Only SELECT statements are auto-committed

Q4: Which method disables auto-commit in JDBC?

A. disableAutoCommit() B. autoCommit(false) C. setAutoCommit(false) D. commit(false)

Q5: Which method rolls back a transaction in JDBC?

A. rollback() B. cancel() C. revert() D. reset()

Q6: Which interface provides transaction management in JDBC?

A. Connection B. Statement C. TransactionManager D. PreparedStatement

Q7: When using manual transaction control, what must be done after executing statements?

A. Close the connection B. Call rollback() C. Call commit() D. Set auto-commit to true

Q8: What happens if commit() is not called after setAutoCommit(false)?

A. Transaction is automatically committed B. Transaction is rolled back by default C. Changes are not saved permanently D. Exception is thrown

Q9: Which JDBC method checks if auto-commit is enabled?

A. isAutoCommit() B. getAutoCommit() C. checkAutoCommit() D. autoCommitStatus()

Q10: What is the purpose of savepoints in JDBC transactions?

A. To run faster queries B. To lock rows during execution C. To mark intermediate points for partial rollback D. To close the connection

Q11: How do you create a savepoint in JDBC?

A. createSavePoint() B. setSavepoint() C. createSavepoint() D. savePoint()

Q12: Which method rolls back to a specific savepoint?

A. rollbackToSavepoint() B. rollback(savepoint) C. revert(savepoint) D. rollbackPoint()

Q13: What is the return type of createSavepoint()?

A. boolean B. void C. Savepoint D. int

Q14: Which method releases a savepoint?

A. releaseSavepoint() B. removeSavepoint() C. deleteSavepoint() D. dropSavepoint()

Q15: What happens if you call rollback() after commit()?

A. It undoes the committed changes B. It throws an exception C. It restarts the transaction D. It ignores rollback silently

Q16: Which interface represents a savepoint in JDBC?

A. Connection B. Savepoint C. Statement D. Rollback

Q17: How can you name a savepoint?

A. Pass a string to createSavepoint() B. Use setName() C. Use nameSavepoint() D. Savepoint cannot be named

Q18: Which exception is thrown when transaction methods fail?

A. SQLException B. TransactionException C. IOException D. RuntimeException

Q19: Can you rollback after releasing a savepoint?

A. Yes B. No C. Only with commit D. Only if auto-commit is true

Q20: When is a transaction considered successful?

A. When connection is closed B. When commit() is called without error C. When rollback() is called D. When auto-commit is false