BUSINESS 3690-51 |solved question on 5.6 LAB - Rollback and savepoint
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.
Escuela, estudio y materia
- Institución
- Chicago State University
- Grado
- BUSINESS 3690-51
Información del documento
- Subido en
- 28 de octubre de 2022
- Número de páginas
- 2
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
Temas
-
chicago state university business business 3690 51