Data Access Question:

Download Job Interview Questions and Answers PDF

Explain What is SAVE POINT?

Oracle Data Access Interview Question
Oracle Data Access Interview Question

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 QuestionNext 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?