Sams Teach Yourself SQL in 21 Days, Fourth Edition

Day 12

Quiz

1:	When nesting transactions, does issuing a ROLLBACK TRANSACTION command cancel the current transaction and roll back the batch of statements into the upper-level transaction? Why or why not?
A1:	No. When nesting transactions, any rollback of a transaction cancels all the transactions currently in progress. The effect of all the transactions will not truly be saved until the outer transaction has been committed.
2:	Can savepoints be used to “save off” portions of a transaction? Why or why not?
A2:	Yes. Savepoints allow the programmer to save off statements within a transaction. If desired, the transaction can then be rolled back to this savepoint instead of to the beginning of the transaction.
3:	Can a COMMIT command be used by itself ...