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 effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to define an oracle cursor variable?
20. Using a set operator, display the client number of all clients who have never placed an order.
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to select an oracle system id (sid)?
What are the most common interview questions on ETL Testing for experience?
What is the parameter mode that can be passed to a procedure?
Who developed oracle & when?
Can we write dml statement in function in oracle?
How can we create the complete backup of data in the oracle.
What is a user role in oracle?
What happens to the current transaction if a ddl statement is executed?
State and explain the different types of data models?
What is bulk load in oracle?
What is a trigger and what are its types in oracle?
