Which of the following Commit allows you to return to the client without waiting for the redo to be written to the disk?

Options
- Synchronous Commit
- Transaction Commit
- Asynchronous Commit
- None of the Above

CORRECT ANSWER : Asynchronous Commit

Discussion Board
Asynchronous Commit

Asynchronous commit is an option that allows transaction to complete more quickly, at the cost that the most recent transactions may be lost if the database should crash. In many applications this is an acceptable trade-off.

Prajakta Pandit 02-20-2017 01:19 AM

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
 
▲