How do you change the tablespace quota for user MTHEO on an Autonomous Database on...

Full Detailed In-Depth Explanation:

In Autonomous Database on Shared Infrastructure, tablespace quotas are managed using standard SQL commands, as administrative packages like DBMS_CLOUD_ADMIN are restricted in this environment. The correct method is:

ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA:This command directly modifies the user’s quota on the DATA tablespace, which is the default tablespace in Autonomous Database. “UNLIMITED” removes any storage restrictions.

Analysis of options:

A:Incorrect. DBMS_CLOUD_ADMIN is used in dedicated infrastructure for advanced administrative tasks, not shared infrastructure for quota changes.

B:Correct. This is the standard SQL syntax supported in shared infrastructure.

C:Incorrect. ALTER TABLESPACE modifies tablespace properties, not user quotas, and isn’t applicable here.

D:Incorrect. ALTER DATABASE syntax is invalid for user quotas; it’s for database-wide settings.