Interested to Buy Any Domain ? << Click Here >> for more details...
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
what is the scenario where you take the database to NoArchivelog mode?
What are a cluster and non-cluster index?
What is oracle used for?
What is Undo Management Advisor in Oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is the difference between truncate & delete command?
Can a parameter be passed to a cursor?
What is a proxy object?
How oracle handles dead locks?
How to define a procedure inside another procedure?
What are the original export and import utilities?
What is the disadvantage of User defind function?
How do I spool in oracle?
How to write a query with a right outer join in oracle?
What is Virtual Private Database in Oracle?
