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

Which two are true about the usage of DBMS_ROLLING?

Answer options

• A. The leading group contains the original primary database.
• B. The trailing group contains the original primary database.
• C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
• D. At least one logical standby database must be part of the initial Data Guard configuration.
• E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

Correct answer: D, E

Explanation

Option D is correct because a logical standby database is a requirement in an initial Data Guard configuration. Option E is also correct as the trailing group can indeed include standby databases that provide protection during the upgrade. Options A and B are incorrect since they misrepresent where the original primary database is located, and Option C, while true, is not one of the selected correct answers.