Exam 1z0-931-20 topic 1 question 23 discussion

D is correct.

On Autonomous Database on Shared Infrastructure, you can change the tablespace quota for a user by executing the following command: D. Execute alter user MTHEO quota unlimited on tablespace DATA; This command will grant an unlimited quota to the user MTHEO on the tablespace DATA. You can replace 'unlimited' with a specific value to set a limit on the tablespace quota. Option A is incorrect because the "alter tablespace" command is used to modify the attributes of a tablespace, not to grant tablespace quota to a user. Option B is incorrect because there is no syntax for "alter tablespace for user" in Oracle Database. Option C is incorrect because DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA is not applicable to Autonomous Database on Shared Infrastructure. It is used for Autonomous Database on Dedicated Infrastructure to grant a tablespace quota to a user. Therefore, the correct option is D.

The alter user is the correct answer. There is no GRANT_TABLESPACE_QUOTA procedure. The link from Koolt demonstrates it. Also google it.

C is correct answer https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0