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

Which two statements are true about Real-Time Query?

Answer options

• A. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.
• B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.
• C. Real-Time Query sessions can be connected to a Far Sync instance.
• D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
• E. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

Correct answer: B, D

Explanation

The correct answer includes B, which is true because turning off Real-Time Query stops the automatic redo apply process when a physical standby is accessed in READ ONLY mode. D is also accurate as Real-Time Query does not impose restrictions on the Data Guard environment's protection level. Options A, C, and E are incorrect because they either misrepresent the requirements for redo transport, the connection capabilities of Real-Time Query, or the failover target restrictions.