How can you use the COMMIT and ROLLBACK commands to support transactions?
What will be an ideal response?
You can use the COMMIT and ROLLBACK commands to support transactions as follows:
Before beginning the updates for a transaction, commit any previous updates by executing the COMMIT command.
Complete the updates for the transaction. If any update cannot be completed, execute the ROLLBACK command and discontinue the updates for the current transaction.
If you can complete all updates successfully, execute the COMMIT command after completing the final update.
Computer Science & Information Technology
You might also like to view...
The Number style in Excel places a comma every three digits to make numbers easier to read
Indicate whether the statement is true or false
Computer Science & Information Technology
________ occur when a website downloads harmful software onto your computer
Fill in the blank(s) with correct word
Computer Science & Information Technology