SQL Transaction Control Language (TCL) 2

Question 1

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

Accepted Answer

COMMIT

Answer

SAVE

Answer

PERSIST

Answer

FLUSH

Question 2

What does the ROLLBACK command do?

Accepted Answer

Undoes changes since the last COMMIT or SAVEPOINT

Answer

Deletes a table

Answer

Locks all rows

Answer

Saves changes permanently

Question 3

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

Accepted Answer

SAVEPOINT

Answer

CHECKPOINT

Answer

MARK

Answer

BOOKMARK

Question 4

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

Accepted Answer

They remain part of the transaction

Answer

They are committed

Answer

They are discarded

Answer

They are locked

Question 5

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

Accepted Answer

RELEASE SAVEPOINT

Answer

DROP SAVEPOINT

Answer

DELETE SAVEPOINT

Answer

REMOVE SAVEPOINT

Question 6

What is the default transaction behavior in many databases like Oracle for DML statements?

Accepted Answer

Changes are uncommitted until COMMIT is issued

Answer

Every statement auto-commits

Answer

Changes are read-only

Answer

Changes roll back automatically

Question 7

Which of these is NOT a TCL command?

Accepted Answer

TRUNCATE

Answer

COMMIT

Answer

ROLLBACK

Answer

SAVEPOINT