New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Fill in the Blanks
Fill in the Blanks

Admon BD Semana 7 - Transacciones ROLLBACK

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

Admon BD Semana 7 - Transacciones ROLLBACK

Fill in the Blanks

Played 0
Create copy

About this activity

Admon BD Semana 7 - Transacciones Ejercicio 2

Created by

Anyelo Gerley Quintero Reyes
Anyelo Gerley Quintero Reyes
Colombia
This game is a version of
Admon BD Semana 7 - Transacciones Ejercicio 2

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
Admon BD Semana 7 - Transacciones ROLLBACK
 

Fill in the Blanks

Admon BD Semana 7 - Transacciones ROLLBACKOnline version

Admon BD Semana 7 - Transacciones Ejercicio 2

by Anyelo Gerley Quintero Reyes
1

Manejo Consistencia Excepciones Errores

Consideraciones en ROLLBACK

* Detección de : Es importante detectar errores durante la ejecución de las operaciones SQL para decidir cuándo aplicar ROLLBACK .
* : Usar ROLLBACK asegura que la base de datos no quede en un estado inconsistente si ocurre un fallo .
* de : En lenguajes procedurales , manejar excepciones de manera adecuada permite que el ROLLBACK se ejecute automáticamente cuando se detecta un error .

2

ROLLBACK autocommit TRANSACTION 0

SET = ; - - ? Autocommit ? deactivado
START ;

SELECT Saldo FROM Clientes WHERE Nombre = " Pablo " ; - - Se verifica que la cuenta exista y que tenga saldo suficiente
SELECT Saldo FROM Clientes WHERE Nombre = " Maria " ; - - Se verifica que la cuenta exista y que tenga saldo suficiente
UPDATE Clientes SET Saldo = Saldo - 10000 WHERE Nombre = " Pablo " ; - - Restando 10 mil pesos
SELECT Saldo FROM Clientes WHERE Nombre = " Pablo " ; - - Verificando que la cuenta de Pablo tenga 10 mil pesos menos
UPDATE Clientes SET Saldo = Saldo + 10000 WHERE Nombre = " Maria " ; - - Actualizando 10000 a Maria
SELECT Saldo FROM Clientes WHERE Nombre = " Maria " ; - - Verificando que la cuenta de Maria tenga 10 mil pesos mas
SELECT * FROM Clientes ;
- - Con ? commit ? al finalizar

; - - REVERTIR TOODOS LOS CAMBIOS ASI EL AUTOCOMMIT ESTE EN 1

3

deshacer COMMIT transacción ROLLBACK confirmar operaciones

USO DE ROLLBACK

Manejo de Errores y Confirmación de Transacción :

* Si todas las operaciones se ejecutan correctamente , usar para la y hacer permanentes los cambios .
* Si ocurre algún error , usar para todas las realizadas durante la transacción .

 
Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.