Data Access Question: Download Questions PDF
Explain 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.
Download Oracle Data Access Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain What is Execution Plan? | Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command? |