Savepoints divide a long transaction into smaller parts

Options
- True
- False


CORRECT ANSWER : True

Discussion Board
Savepoints

The above statement is true. Savepoints divide a long transaction into smaller parts. You can declare intermediate markers called savepoints within the context of a transaction. Using savepoints, you can arbitrarily mark your work at any point within a long transaction. Savepoints are similarly useful in application programs. If a procedure contains several functions then you can create a savepoint before each function begins. Then, if a function fails, it is easy to return the data to its state before the function began and re-run the function with revised parameters or perform a recovery action.

Prajakta Pandit 02-19-2017 10:49 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement