Answer Posted / shilpa chandramohanan
A savepoint is a marker within the transaction used for
partial rollback. As changes are made in a transaction, we
can create SAVEPOINTs to mark different points within the
transaction. If we encounter an error, we can rollback to a
SAVEPOINT or all the way back to the beginning of the
transaction.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Is oracle an operator?
What is data file?
How to define an external table with a text file?
Write a trigger example in oracle?
What are the restrictions in a oracle read only transaction?
Explain the use of online redo log files in oracle.
What is a Garbage Collection? and what is full recursive Garbage collection?
What is Undo Management Advisor in Oracle?
What are the different types of trigger and explain its various uses and functions?
What is difference between cartesian join and cross join?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are triggers in oracle?
Explain the use of constraints option in exp command.
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to revoke create session privilege from a user in oracle?