Exam 1z0-066 topic 1 question 48 discussion

Actual exam question from Oracle's 1z0-066

Question #: 48
Topic #: 1

[All 1z0-066 Questions]

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

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.

Show Suggested Answer

Suggested Answer: ADE 🗳️
D: The COMPATIBLE database initialization parameter must be set to 11.0 or higher to use the real-time query feature of the Oracle Active Data Guard option.
E: The apply lag control and Redo Apply synchronization mechanisms require that the client be connected and issuing queries to a physical standby database that is in real-time query mode.
Incorrect Answers:
C: The standby database must receive redo data via the SYNC transport.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ps.htm#SBYDB00707

by Kamaelk at Oct. 23, 2019, 4:11 a.m.