Oracle Exam 1Z0-066 Topic 9 Question 41 Discussion

A: SQL Apply converts the data from the archived redo log or standby redo log in to SQL statements and then executes these SQL statements on the logical standby database.

Note: Log apply services use the following methods to maintain physical and logical standby databases:

* Redo apply (physical standby databases only)

* SQL Apply (logical standby databases only)

E: Standby redo log files are required to use real-time apply.

By default, the redo data is applied from archived redo log files. When performing Redo Apply, a physical standby database can use the real-time apply feature to apply redo directly from the standby redo log files as they are being written by the RFS process.

Applying Redo Data to Physical Standby Databases

C: The archiver (ARCn) process or the log writer (LGWR) process on the primary database can transmit redo data directly to remote standby redo log files, potentially eliminating the need to register a partial archived log file (for example, to recover after a standby database crashes).