You execute some DMLcommands, followed by a COMMIT Statement.
Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?
A. 1. LGWR writes the commit record to disk.2. LGWR writes all redo entries from Redo Log Buffer to disk.
B. 1. GWR writes only the transaction’s redo entries from Redo Log Buffer to disk.2. LGWR writes the commit record to disk.
C. 1. LGWR puts the commit record to Redo Log Buffer.2. IGWR writes all redo entries from Redo Log Buffer to disk.
D. 1. LGWR puts the commit record to Redo Log Buffer.2. If the activity is high, LGWR waits three seconds for other transactions to commit.3. LGWR writes all redo log entries from Redo Log Buffer to disk.
E. 1. LGWR puts the commit record to Redo Log Buffer.2. LGWR signals the database writer (DBW) process to write dirty blocks to disk.3. LGWR writes all redo entries from Redo Log Buffer to disk.
|
Download Printable PDF. VALID exam to help you PASS. |
 |