Why do we use Commit and Rollback commands?

Q 28. Why do we use Commit and Rollback commands?

Ans :

COMMIT

ROLLBACK

COMMIT permanently saves the changes made by the current transaction.

ROLLBACK undo the changes made by the current transaction.

The transaction can not undo changes after COMMIT execution.

Transaction reaches its previous state after ROLLBACK.

When the transaction is successful, COMMIT is applied.

When the transaction is aborted, ROLLBACK occurs.

Donate to  grow Studyandupdates

स्टडीएंडअपडेट्स को विकसित करने के लिए  मदत करें

To Provide  more Services among Student

छात्र के बीच अधिक से अधिक  सेवाएं प्रदान करने के लिए