1Z0-078 practice question 11 of 15

Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

Answer options

A: Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.

B: Transparent Application Continuity is enabled when failover type=auto. Correct answer

C: Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes. Correct answer

D: Recovery of the user database session is done safely by enabling auto recover within the user database session.

E: Transparent Application Continuity is enabled when failover type=All

Correct Answer:

B. Transparent Application Continuity is enabled when failover type=auto.; C. Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.

Explanation

Transparent Application Continuity (TAC) is enabled for a database service by setting -failovertype AUTO; this allows Oracle to capture and replay user calls automatically after recoverable outages. The replay is executed by the database, so sessions are recovered safely with no application code changes or DBA intervention, fulfilling TAC’s goal of transparent recovery.

Why Incorrect

A. TAC is enabled by service attributes, not automatically when a session reaches a “safe place.”
D. No client-side “auto recover” setting is required; recovery is handled by TAC infrastructure.
E. “ALL” is not a valid failover type for enabling TAC; AUTO is required.

References

1. Oracle RAC Admin & Deployment Guide 19c, ch. 14 “Configuring Transparent Application Continuity”, Step 2 (srvctl … -failovertype AUTO) (E96332-15).

2. Same guide, “Benefits of Transparent Application Continuity”, bullets 1-2, explaining no application changes needed.

Keep practicing

Take the free 1Z0-078 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test