OCM OCM High Availability & Disaster Recovery 2

Question 1

What Oracle technology provides application-level, transparent failover for database connections during a planned or unplanned outage?

Accepted Answer

Application Continuity (AC)

Answer

Application Continuity replays in-flight transactions on a new database session after a recoverable failure, making the outage transparent to the application without code changes.

Question 2

In Oracle Data Guard, which protection mode guarantees zero data loss by requiring the standby to acknowledge redo receipt before the primary commits?

Accepted Answer

Maximum Protection

Answer

Maximum Protection mode requires at least one standby to confirm redo receipt before each primary transaction commits; if no standby is reachable, the primary shuts down.

Question 3

Which Oracle utility is used to clone a database or create a standby database directly from the primary without prior backups?

Accepted Answer

RMAN DUPLICATE … FROM ACTIVE DATABASE

Answer

RMAN DUPLICATE … FROM ACTIVE DATABASE streams datafiles directly from the primary (or auxiliary) instance over an Oracle Net connection to build a clone or standby without needing RMAN backups.

Question 4

What is the role of the Oracle Notification Service (ONS) in a RAC or Data Guard environment?

Accepted Answer

Publishing Fast Application Notification (FAN) events to middleware and connection pools about service state changes

Answer

ONS propagates FAN events (instance up/down, service relocate) from the cluster to JDBC/OCI connection pools and middleware, enabling rapid connection failover and load balancing.

Question 5

In Oracle Data Guard Broker, what is the purpose of the DGMGRL command SWITCHOVER TO?

Accepted Answer

Performs a planned role transition with no data loss between primary and standby

Answer

SWITCHOVER TO performs an orderly, zero-data-loss role reversal where the current primary becomes a standby and the target standby becomes the new primary.

OCM - Oracle Certified Master Practice Test

OCM - Oracle Certified Master Practice Test

OCM OCM High Availability & Disaster Recovery 2