Home > Articles > Data > MySQL

  • Print
  • + Share This
This chapter is from the book

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

  1. What are the four basic properties of transactions? Hint: think "ACID."

  2. What SQL statement should be used to indicate that subsequent statements form a transaction?

  3. If query #3 of a 5-query transaction fails, what SQL command should be issued so affected tables revert to their previous state?

Answers

  1. Atomicity, consistency, isolation, and durability.

  2. BEGIN WORK

  3. 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.

  • + Share This
  • 🔖 Save To Your Account