Workshop
The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “Answers.”
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? |
| 2: | Can savepoints be used to “save off” portions of a transaction? Why or why not? |
| 3: | Can a COMMIT command be used by itself or must it be embedded? |
| 4: | If you issue the COMMIT command and then discover a mistake, can you still use the ROLLBACK command? |
| 5: | Will using a savepoint ... |
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
