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.

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