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

Which three are always benefits of using a logical standby database?

Answer options

• A. It can be used for database rolling release upgrades.
• B. It can be used to replicate a single pluggable database (PDB) in a multitenant container database.
• C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
• D. It can be used for reporting workloads requiring additional indexes or materialized views or both.
• E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
• F. It can be used for testing patches without affecting the primary database.

Correct answer: C, D, F

Explanation

Answer C is correct because logical standby databases allow updates for Real Application Testing and can revert to standby status without losing changes. Option D is also valid as logical standby databases can handle reporting workloads with added indexes. Answer F is correct since it enables patch testing without affecting the primary database, while options A, B, and E do not consistently apply as benefits of logical standby databases.