DAT 390 Wk 2 – Apply: Labs

Complete zyLab 2.6 and 2.7 in zyBooks. You have unlimited attempts in Develop mode. Toggle to Submit mode for a grade.

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:

1. Insert a new actor with values 999, ‘NICOLE’, ‘STREEP’, ‘2021-06-01 12:00:00’
2. Set a SAVEPOINT.
3. Delete the actor with first name ‘CUBA’.
4. Select all actors.
5. Roll back to the savepoint.
6. Select all actors a second time.

The actor with first name ‘CUBA’ should appear in the second SELECT but not the first.