Question: 2 . 6 LAB - Rollback and savepoint ( Sakila ) Refer to the actor table of the Sakila database. The table in this lab
LAB Rollback and savepoint Sakila
Refer to the actor table of the Sakila database. The table in this lab has the same columns and data types but fewer rows.
Start a transaction and:
Insert a new actor with values 'NICOLE', 'STREEP', ::
Set a SAVEPOINT.
Delete the actor with first name 'CUBA'.
Select all actors.
Roll back to the savepoint.
Select all actors a second time.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
