Workshop
The Workshop is designed to help you anticipate possible questions, review what you've learned, and begin learning how to put your knowledge into practice.
Quiz
What are the four basic properties of transactions? Hint: think "ACID."
What SQL statement should be used to indicate that subsequent statements form a transaction?
If query #3 of a 5-query transaction fails, what SQL command should be issued so affected tables revert to their previous state?
Answers
Atomicity, consistency, isolation, and durability.
BEGIN WORK
ROLLBACK
Activity
Based on the table design of your contact management system, think about how the tables relate to each other and how transactions would help maintain the integrity of your data. Think about inserting records in logical groupings, as well as deleting related records.