Multiple choice

Which of these techniques used in database transactions is also called UNDO/REDO technique?

  1. Deferred update

  2. Immediate update

  3. Rollback

  4. Commit

  5. Phantom reads
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Immediate update also called UNDO/REDO, is also another technique used to recover/support transaction failures that occur due to operating system, power, memory or machine failures. When a transaction runs, any of the updates or alterations made by the transaction are written directly in to the database.

Keep practicing — related questions