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

Which four requirements can be met by deploying a logical standby database?

Answer options

• A. Support for workloads requiring additional indexes.
• B. It can be used to create additional schemas.
• C. It can be used to create additional tables.
• D. It must have the same physical structure as the primary database.
• E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
• F. Support for workloads requiring additional materialized views.
• G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.

Correct answer: A, C, E, G

Explanation

The correct answer includes A, C, E, and G because a logical standby database indeed supports additional indexes and tables, provides disaster recovery capabilities with switchover and failover options, and allows for Real Application Testing. Options B, D, and F are incorrect as they do not align with the specific advantages of a logical standby database.