Interview Question

What is COMMIT?

COMMIT permanently completes the current transaction.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

COMMIT ends the current transaction and makes its changes permanent. • After commit, rollback cannot undo that transaction. • Other transactions see the changes according to their isolation rules. • Commit should happen only after every required statement succeeds.

💡 SQL Example

COMMIT;

Result

COMMIT

⚡ Quick Revision

COMMIT permanently completes the current transaction.