DAT/390 Database Integration with Other Systems The Latest Version A+ Study Guide **********************************************
DAT 390 Entire Course Link https://www.onlinehelp123.com/dat-390 ********************************************** 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. 2. 3. 4. 5. 6.
Insert a new actor with values 999, 'NICOLE', 'STREEP', '2021-06-01 12:00:00' Set a SAVEPOINT. Delete the actor with first name 'CUBA'. Select all actors. Roll back to the savepoint. Select all actors a second time.
The actor with first name 'CUBA' should appear in the second SELECT but not the first.
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. 2. 3. 4.
Insert a new actor with values 999, 'NICOLE', 'STREEP', '2021-06-01 12:00:00' Set a SAVEPOINT. Delete the actor with first name 'CUBA'. 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.