Exercise: Transactions and Concurrency Control
Practice and test your understanding of transactions and concurrency control.
We'll cover the following...
Let’s get some hands-on practice!
Question 1
Given the following structure of the Categories table:
Field | Type |
|
|
|
|
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.
-- Demonstrating transaction rollback with an insert into the Categories table
If you’re stuck, click the “Show Solution” button.
Question 2
Given the following structure of the Customers table:
Field | Type |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Where CustomerID is the primary key and ReferralID is ...