No user-defined locks are used in your database.Which three are true about Transaction Control Language (TCL)? (Choose three.)
A. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases its locks, and erases all its savepoints.
B. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.
C. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.
D. ROLLBACK TO SAVEPOINT undoes the transaction's changes made since the named savepoint and then ends the transaction. E. COMMIT ends the transaction and makes all its changes permanent. F. COMMIT erases all the transaction's savepoints and releases its locks.
No user-defined locks are used in your database.Which three are true about Transaction Control Language (TCL)? (Choose t
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am