________ ends the transaction and undoes the changes

Options
- Commit
- Rollback
- Revoke
- Savepoint

CORRECT ANSWER : Rollback

Discussion Board
ROLLBACK

Using ROLLBACK without the TO SAVEPOINT clause performs the following operations:
- Ends the transaction.
- Undoes all changes in the current transaction.
- Erases all savepoints in the transaction.
- Releases any transaction locks.
Specify the savepoint to which you want to roll back the current transaction. If you omit TO SAVEPOINT clause, the ROLLBACK statement rolls back the entire transaction.

Prajakta Pandit 02-22-2017 01:42 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲