Exercise: Transactions and Concurrency Control

Let’s get some hands-on practice!

Question 1

Given the following structure of the Categories table:

Where CategoryID is the primary key. The table contains information about categories of products.

Start a transaction, insert a new category named Office Supplies into the Categories table. Then, immediately roll back the transaction. Finally, verify that the Office Supplies category was not permanently added. 

If you’re stuck, click the “Show Solution” button.

Question 2

Given the following structure of the Customers table:

Where CustomerID is the primary key and ReferralID is ...