Explain MySQL transaction properties?

Posted by Prem Tiwari | Updated on

This is the most asked MySQL Interview Questions asked in an interview. The transactions mainly consist of four properties.

  1. Atomicity: The property is mainly used to control all the operations and ensure all the transactions get completed successfully.
  2. Consistency: This ensures the database changes according to the successfully committed transactions.
  3. Isolation: This is basically used to control the independent transactions.
  4. Durability: This is used to control and measure the effect and presence of committed transactions in case of system or database failure.

If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

Related Questions & Answers