InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Save Point ? |
|
Answer» For long transactions that CONTAIN many SQL statements, INTERMEDIATE markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later ROLLING back all WORK performed from the current point in the transaction to a declared savepoint within the transaction. For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction. |
|