Exam (elaborations)
BUSINESS 3690-51 |solved question on 5.6 LAB - Rollback and savepoint
Rating
Sold
-
Pages
2
Grade
A+
Uploaded on
28-10-2022
Written in
2022/2023
5.6 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: 1. Insert a new actor with values 999, 'NICOLE', 'STREEP', ':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. NOTE: In submit-mode tests that generate multiple result tables, the results are merged. Although the tests run correctly, the results appear in one table.
Show more
Read less
Institution
Chicago State University
Course
BUSINESS 3690-51
Whoops! We can’t load your doc right now. Try again or contact support.
Written for
- Institution
-
Chicago State University
- Course
-
BUSINESS 3690-51
Document information
- Uploaded on
- October 28, 2022
- Number of pages
- 2
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
chicago state university business business 3690 51
$5.99
Get access to the full document:
100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached
