Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared Infrastructure?

On Oracle Autonomous Database on Shared Infrastructure, many administrative tasks that would traditionally use ALTER SYSTEM or ALTER DATABASE commands are managed through dedicated PL/SQL packages. To enable Application Continuity, the administrator must use the ENABLEAPPCONT procedure within the DBMSCLOUDADMIN package. This procedure enables the feature for a specified predefined database service (e.g., 'HIGH', 'MEDIUM'). This method is consistent with the managed service model of Autonomous Database, which abstracts direct system-level modifications to ensure stability and autonomous operation.

A. ALTER SESSION SET APPLICATIONCONTINUITY=TRUE only modifies the behavior for the current session and does not enable the feature at the service level.
C. ALTER DATABASE is used for modifying the physical or logical structure of the database, not for enabling service-level features like Application Continuity on Autonomous Database.
D. ALTER SYSTEM is the standard command for on-premises databases, but this privilege is restricted on Autonomous Database for this purpose to maintain the service's autonomous nature.

1. Oracle Cloud Infrastructure Documentation. (2024). Using Oracle Autonomous Database on Shared Exadata Infrastructure. Section: "Use Application Continuity on Autonomous Database".

The documentation explicitly states: "By default Application Continuity is not enabled on Autonomous Database. To enable Application Continuity

connect as the ADMIN user and run the following command: EXEC DBMSCLOUDADMIN.ENABLEAPPCONT('HIGH');" This confirms that the DBMSCLOUDADMIN.ENABLEAPPCONT procedure is the correct method.

2. Oracle Cloud Infrastructure Documentation. (2024). PL/SQL Packages and Types Reference. Chapter: "DBMSCLOUDADMIN Package".

This reference details the procedures available in the DBMSCLOUDADMIN package. The ENABLEAPPCONT procedure is documented here as the method for enabling Application Continuity on a specified service within an Autonomous Database instance.