mediumDSA

What are COMMIT, ROLLBACK, and SAVEPOINT?

Q: What are COMMIT, ROLLBACK, and SAVEPOINT?

**COMMIT** makes a transaction's changes permanent; **ROLLBACK** undoes them. A **SAVEPOINT** marks a point you can partially roll back to (`ROLLBACK TO savepoint`) without aborting the whole transaction — useful for handling errors in part of a batch.

1.1k views

Understand the problem

Explain transaction control.

transactions

Attempt it yourself

Sketch your approach before reading the solution — that's what interviews test.

Nudge consolestandby

Stuck? Beam a request up — the console returns a conceptual nudge that guides your logic without spoiling the implementation.

Study the solution

COMMIT makes a transaction's changes permanent; ROLLBACK undoes them. A SAVEPOINT marks a point you can partially roll back to (ROLLBACK TO savepoint) without aborting the whole transaction — useful for handling errors in part of a batch.

Solution ready — 2 min read

Classified // press E to declassify

Run the code

SQLTransaction Control Playground

Join the discussion

Discussion (0)

No responses yet. Be the first to share what you think.

Transmission complete // awaiting log

KEEP THE
STREAK ALIVE.

Dossier 22 of 70 decoded in the SQL track. One more won't hurt.

Back to track

Next up→

How do you aggregate values into a single string?

Continue