Multiple choice technology databases

Identify SQL statement which is used as Transaction Control Language command. Choose all that apply.

  1. Alter

  2. Rollback

  3. Select

  4. Commit

  5. Rename

  6. Savepoint

Reveal answer Fill a bubble to check yourself
B,D,F Correct answer
Explanation

Transaction Control Language (TCL) commands manage transactions: Rollback undoes changes, Commit permanently saves changes, and Savepoint sets intermediate rollback points. Alter and Rename are DDL structure commands, Select is for retrieval.