In a nutshell, these are the SQL rules regarding transaction control.
We must be very careful when using COMMIT and ROLLBACK – in other words, when we are changing the state of our data set.
The condition here is to have an employee number that equals John Smith’s number, 999901.
The data base on which the algorithm updates are founded is refreshed every once in a while.
A “Data Refresh” describes the process of updating the data base at the foundation of the particular algorithm update.
Please note that it will be very hard to practice these statements unless we switch off the following feature of Workbench.
We can expand the Edit tab from the Main Menu and opt for “Preferences”.