How do you handle your own transaction ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

11. How do you handle your own transaction ?

Connection Object has a method called setAutocommit(Boolean istrue)
Default is true. Set the Parameter to false , and begin your transaction

(Continued on next question...)

Other Job Interview Questions

• What is Metadata and why should I use it?
• Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
• What is Metadata and why should I use it?
• Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
• What are different types of Transaction Isolation Levels?
• How do you handle your own transaction ?
• How do you handle your own transaction ?
• What is Metadata and why should I use it?
• Is the JDBC-ODBC Bridge multi-threaded?
• What is cold backup, hot backup, warm backup recovery?
• More...