Suggested Answer:BD🗳️
If a license for the Oracle Active Data Guard option has been purchased, Redo Apply can be active while the physical standby database is open, thus allowing queries to return results that are identical to what would be returned from the primary database. This capability is known as the real-time query feature. Incorrect Answers: A: If STANDBY_MAX_DATA_DELAY is set to 0, a query issued to a physical standby database is guaranteed to return the exact same result as if the query were issued on the primary database, unless the standby database is lagging behind the primary database, in which case an ORA-3172 error is returned. Note: The STANDBY_MAX_DATA_DELAY session parameter can be used to specify a session-specific apply lag tolerance, measured in seconds, for queries issued by non-administrative users to a physical standby database that is in real-time query mode. This capability allows queries to be safely offloaded from the primary database to a physical standby database, because it is possible to detect if the standby database has become unacceptably stale.
To support zero lag, the primary database must operate in maximum availability or maximum
protection mode. Protection modes will be discussed later in the course.
Specify SYNC for redo transport mode.
Real-time query must be enabled as a prerequisite for configuring zero lag.
So D is wrong
Configuring Zero Lag Between the Primary and
Standby DatabasesStandby Databases
• Certain applications have zero tolerance for any lag.
• A query on the standby database must return the same
result as if it were executed on the primary database.
• Enforce by setting STANDBY MAX DATA DELAY to 0Enforce by setting STANDBY_MAX_DATA_DELAY to 0.
• The standby database must have advanced to a value
equal to that of the current SCN on the primary database
at the time the query was issued.
• Results are guaranteed to be the same as the primary
database; otherwise an ORA 3172 error is returneddatabase; otherwise, an ORA-3172 error is returned.
• The primary database must operate in maximum
availability or maximum protection mode.
• SYNC must be specified for redo transport.
• Real-time query must be enabled.
So right answers are: AB
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JESUSBB
2 years, 5 months agoYoones
3 years, 7 months agoYoones
3 years, 7 months ago