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.
You might also like to view...
A ________ allows a user to view multiple folders in File Explorer simultaneously
A) file B) dialog box C) library D) Zip file
Which of the following must be included in a smartphone you want to use as a TV or home theater remote?
a. Infrared. b. Wi-Fi. c. Bluetooth. d. HDMI port.
Using the _________ cipher you select multiple numbers by which to shift letters
a. DC4 b. Caesar c. Multi-alphabet substitution d. ASCII
To format a side heading of a report, apply the ____ style.
A. Heading 1 B. Heading 2 C. Heading 3 D. Title