SQL Transaction Control Language (TCL) 2

Question 1

Which TCL command permanently saves all changes made during the current transaction?

Accepted Answer

COMMIT

Answer

COMMIT makes all changes in the current transaction permanent and visible to other sessions.

Question 2

What does the ROLLBACK command do?

Accepted Answer

Undoes changes since the last COMMIT or SAVEPOINT

Answer

ROLLBACK reverses uncommitted changes back to the last commit or a specified savepoint.

Question 3

Which statement creates a point within a transaction you can later roll back to?

Accepted Answer

SAVEPOINT

Answer

SAVEPOINT defines a named marker within a transaction for partial rollback.

Question 4

After ROLLBACK TO SAVEPOINT sp1, what happens to changes made before sp1?

Accepted Answer

They remain part of the transaction

Answer

Only changes made after the savepoint are undone; earlier changes stay until commit or rollback.

Question 5

Which TCL command is used to release a savepoint without rolling back?

Accepted Answer

RELEASE SAVEPOINT

Answer

RELEASE SAVEPOINT removes a savepoint so it can no longer be used as a rollback target.

SQL Practice Test