What is two-phase commit in the database?
It is a standardized protocol assuring the implementation of a database commit in such a situation where the commit operation has to be broken into 2 parts. Saving the changes in the database is called commit whereas, rollback is undoing the changes. In the first phase of the commit, data is written into the data records by the servers needing commit data to the log. In the next step, it begins after getting the successful message from the previous phase, and the particular object, i.e., the coordinator, sends a signal to each server with the instructions of the commit.
BY Best Interview Question ON 10 Apr 2019