|
Explain “Commit” and “Roll back”
SAP Reports,SAP DB,ALE, SAP Tables questions and answers
(Continued from previous question...)
Explain “Commit” and “Roll back”
The Oracle RDBMS provides a transaction model based on a unit of work. The PL/SQL language supports most, but not all, of the database model for transactions (you cannot, for example, ROLLBACK FORCE). Transactions begin with the first change to data and end with either a COMMIT or ROLLBACK.
COMMIT makes the database changes permanent and visible to other database sessions.
ROLLBACK undoes the changes made in the current transaction either to the beginning of the transaction or to a savepoint. A savepoint is a named processing point in a transaction, created with the SAVEPOINT statement. Rolling back to a savepoint is a partial rollback of a transaction, wiping out all changes (and savepoints) that occurred later than the named savepoint.
(Continued on next question...)
Other Interview Questions
| 