Multiple choice technology databases

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)

  1. SYNC or ASYNC to identify the network transmission mode.

  2. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

  3. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

  4. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

The LOG_ARCHIVE_DEST_n parameters use SYNC/ASYNC for network transmission mode (synchronous or asynchronous), LGWR/ARCH to specify which primary process sends redo (LGWR for real-time, ARCH for archiver), and AFFIRM/NOAFFIRM to control whether disk writes are synchronous (AFFIRM) or asynchronous (NOAFFIRM). These three attributes directly control data availability and protection modes in Data Guard. Option D mentions PROTECTED/UNPROTECTED which are high-level availability modes, not individual parameters.

Keep practicing — related questions