Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 72

Which three statements are true about Data Guard database modes and states? (Choose three.)

Answer options

• A. A primary database may ship redo directly to more than mine standby databases.
• B. Force Logging Mode is not required for a primary database but is recommended.
• C. A Logical Standby Database can be in MOUNT state while applying changes.
• D. The Primary Database can operate in noarchivelog mode.
• E. Databases in a Data Guard Configuration need not operate in Flashback Logging mode.

Correct answer: A, B, C

Explanation

Option A is correct because a primary database can indeed send redo data to multiple standby databases. Option B is also correct as it is advisable for a primary database to use Force Logging Mode to ensure all changes are captured. Option C is correct since a Logical Standby Database can be in the MOUNT state during change application. Options D and E are incorrect; a primary database must operate in ARCHIVELOG mode for Data Guard, and Flashback Logging is typically recommended for better recovery options.