What oracle does if one program fails in the middle of a transaction?

Options
- Rollback and restore database
- Only rollback
- Direct restore
- End

CORRECT ANSWER : Rollback and restore database

Discussion Board
Rollback and restore database

Oracle is transaction oriented; that is, it uses transactions to ensure data integrity. A transaction is a series of one or more logically related SQL statements, you define to accomplish some task. Oracle treats the series of SQL statements as a unit so that all the changes brought about by the statements are either committed (made permanent) or rolled back (undone) at the same time. If your application program fails in the middle of a transaction, the database is automatically restored to its former (pre-transaction) state.

Prajakta Pandit 02-21-2017 11:01 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲