A refreshable clone in Autonomous Database is a read-only copy of a source database that syncs periodically, but it has a refresh time limit (typically 7 days). Once this limit is exceeded, specific actions are available. The two correct options are:

You can disconnect from the source to make the database a read/write database (B):After the refresh time limit passes, the clone can no longer sync with the source. You can “disconnect” it (via the OCI console or API, e.g., oci db autonomous-database update --is-refreshable-clone false), converting it into an independent, read/write Autonomous Database. This requires a new license and incurs full costs, but it allows modifications (e.g., INSERT or UPDATE) that were blocked in read-only mode. For example, a test clone might be disconnected to become a production instance after testing.

You can use the instance as a read-only database (C):Even after the refresh limit, the clone remains functional as a read-only database, retaining its last refreshed state. You can query it (e.g., SELECT * FROM sales) for analysis or reporting without further refreshes, though it won’t reflect source updates. This is useful if ongoing read-only access suffices without needing write capabilities.

The incorrect options are:

You can manually refresh the clone (A):False. Once the refresh time limit (e.g., 7 days) is exceeded, manual refreshes are not possible. The clone’s refresh capability expires, and it can’t sync again unless recreated. This is a fixed constraint to manage resource usage in ADB.

You can extend the refresh time limit (D):False. The refresh period (set during clonecreation, max 7 days) cannot be extended after provisioning. You’d need to create a new clone with a longer limit if needed, but post-expiry, no extension is allowed.

These options provide flexibility post-expiry, balancing read-only continuity and full database conversion.