What is Two-Phase Commit?

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

(Continued from previous question...)

224. What is Two-Phase Commit?

Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.

(Continued on next question...)

Other Job Interview Questions

• You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
• Can Full Backup be performed when the database is open?
• Tablespaces
• What are the more common pseudo-columns?
• What is the Maximum allowed length of Record group Column?
• Explain about stacked canvas views?
• If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
• Can a property clause itself be based on a property clause?
• How to define Data Block size?
• What is the Maximum allowed length of Record group Column?
• More...