Change Tablespace Quota for User on Autonomous Database

C.

The correct answer is D. Execute alter user MTHEO quota unlimited on tablespace DATA.

Explanation: To change the tablespace quota for a user on an Autonomous Database on Shared Infrastructure, you can use the ALTER USER command with the QUOTA clause. This clause allows you to specify the maximum amount of space that a user can consume in a particular tablespace. The syntax for the command is as follows:

ALTER USER [username] QUOTA [quota] ON [tablespace];

Where:

• [username] is the name of the user whose quota you want to change.
• [quota] is the new quota that you want to set for the user, specified in bytes, kilobytes, megabytes, gigabytes, or terabytes. You can also use the keyword UNLIMITED to specify no limit on the quota.
• [tablespace] is the name of the tablespace for which you want to set the quota.

Option A is incorrect because it only changes the quota for the entire tablespace and not for a specific user. Option B is incorrect because the ALTER TABLESPACE command cannot be used to set quotas for individual users. Option C is incorrect because it uses the DBMS_CLOUD_ADMIN package, which is not relevant for changing tablespace quotas.

Therefore, option D is the correct answer because it uses the ALTER USER command with the QUOTA clause to set the new quota for the user "MTHEO" to unlimited on the tablespace "DATA".