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

Which three are required in order to use Real-Time Query without lagging behind the primary?

Answer options

• A. There must be standby redo logs on the standby database.
• B. There must be standby redo logs on the primary database.
• C. The primary must ship redo asynchronously.
• D. COMPATIBLE must be set to 11.1.0 or higher.
• E. Real-Time apply must be enabled on the standby.

Correct answer: A, D, E

Explanation

The correct answer includes A, D, and E because standby redo logs on the standby database, a compatible version, and enabled Real-Time apply are essential for Real-Time Query functionality without delays. Option B is incorrect as the primary database does not require standby redo logs, and option C is not necessary since Real-Time Query relies on the synchronous application of redo logs on the standby.