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

Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

Answer options

• A. If the CACHE option is set then the size of the cache must be at least 100.
• B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary.
• C. Their usage will always have a performance impact on the primary database.
• D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
• E. They must have the NOORDER and CACHE options set.

Correct answer: B, D, E

Explanation

Option B is correct because Global Sequences require a defined LOG_ARCHIVE_DEST_n parameter to function properly with the primary database. Option D is also correct, as a small CACHE size can negatively affect the performance of the physical standby database. Option E is correct because Global Sequences need both the NOORDER and CACHE options to be set, while options A and C are not universally true and can be misleading.