Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 6. Managing Database Transactions
The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. Refer to Appendix C,"Answers to Quizzes and Exercises," for answers.
Quiz
1:
True or false: If you have committed several transactions, have several more transactions that have not been committed, and issue a ROLLBACK command, all your transactions for the same session are undone.
2:
True or false: A SAVEPOINT actually saves transactions after a specified amount of transactions have executed.
3:
Briefly describe the purpose of each one of the following commands: COMMIT, ROLLBACK, and SAVEPOINT.
Exercises
Q1:
Take the following transactions and create SAVEPOINTs after every three transactions. Then, COMMIT the transactions. Write this out on a sheet of paper, since MySQL does not currently support transactional control.
