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

Oracle Net Services Load Balancing

Answer

Transparent Application Failover (TAF)

Answer

Fast Application Notification (FAN)

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 Performance

Answer

Maximum Availability

Answer

Synchronous Replication

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

Data Pump impdp

Answer

SQL*Loader

Answer

GoldenGate Initial Load

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

Encrypting redo data sent to standby databases

Answer

Managing redo log archival across all RAC instances

Answer

Distributing SQL execution plans to all cluster nodes

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

Forces an emergency failover when the primary is unavailable

Answer

Converts a physical standby to a logical standby

Answer

Resynchronizes a lag standby after network interruption

Question 6

Which Oracle feature automatically extends a tablespace by adding a new datafile or expanding an existing one when space runs out?

Accepted Answer

Automatic Extensible Datafiles (AUTOEXTEND ON)

Answer

Locally Managed Tablespace

Answer

Bigfile Tablespace

Answer

Automatic Segment Management