How can you use the COMMIT and ROLLBACK commands to support transactions?


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.

Business

You might also like to view...

The account ‘Wages Payable' would appear on the income statement

Indicate whether the statement is true or false

Business

Which term refers to the qualitative value of message exposure through a given medium?

A) reach B) turnover rate C) efficiency D) media impact E) frequency

Business

A company is said to be a direct foreign investor in another country if it:

a. outsources a part of its production to the country due to the availability of cheaper labor. b. exports finished products to that country. c. manufactures products for that country based on contract manufacturing. d. acquires an active ownership of marketing facilities in that country.

Business

The interest that is earned or charged on both the principal amount and on the accrued interest

that has been previously earned or charged is A) simple interest. B) accrued interest. C) compound interest. D) stated interest.

Business