# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 2052611724

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Demonstrate the use of SAVEPOINT, ROLLBACK, and COMMIT.

Definition

Demonstration should include a process flow that demonstrates the following, in order (with autocommit turned off):
  1. Execute a transaction against the data (insert or update).
  2. Execute a transaction against the data (insert or update).
  3. Create SAVE POINTA.
  4. Execute a transaction against the data (insert or update).
  5. Execute a transaction against the data (insert or update).
  6. Create SAVE POINTB.
  7. Execute a transaction against the data (insert or update).
  8. ROLLBACK to SAVEPOINTA.
  9. Execute a transaction against the data (insert or update).
  10. Execute a transaction against the data (insert or update).
  11. COMMIT.
  12. Run a query and validate the updates made to the data.