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 Ejercicio 2

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 Ejercicio 2

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 y Bloqueos

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 Ejercicio 2
 

Fill in the Blanks

Admon BD Semana 7 - Transacciones Ejercicio 2Online version

Admon BD Semana 7 - Transacciones Ejercicio 2

by Anyelo Gerley Quintero Reyes
1

COMMIT original confirman TRANSACTION Operaciones cambios ROLLBACK SQL revierten estado

Cual es el proceso lógico del código en SQL para indicar una transacción :
1 . START : Inicia una nueva transacción .
2 . : Realiza las operaciones de debitar y acreditar dinero .
3 . : Si ambas operaciones se realizan correctamente , se los .
4 . : Si alguna de las operaciones falla , todos los cambios se y la base de datos regresa a su antes de iniciar la transacción .

2

Datos Manejo Errores Sistema

Importancia de la Atomicidad :
1 . Integridad de los .
2 . Fiabilidad del
3 . Simplificación de de

3

COMMIT 0 TRANSACTION START

TRANSACCIÓN EN SQL CON CONFIRMACION PARA CAMBIOS

SET autocommit = ; - - ? Autocommit ? deactivado
;

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 ;
;

 
Are you sure you want to leave the page?

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