Oracle Cloud Infrastructure 2020 Architect Associate — Question 34

How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure? (Choose the best answer.)

Answer options

• A. Execute alter tablespace DATA set quota = 10G;
• B. Execute alter tablespace for user MTHEO tablespace DATA quota = 10G;
• C. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO',tablespace_quota => 'UNLIMITED');
• D. Execute alter user MTHEO quota unlimited on tablespace DATA;

Correct answer: D

Explanation

The correct answer D is valid because it directly modifies the user MTHEO's quota on the DATA tablespace to unlimited. Option A incorrectly attempts to set a quota without specifying a user, while option B uses the wrong syntax for altering a user's tablespace quota. Option C is also incorrect because it grants unlimited quota, but it is not the most direct method to alter the user's quota as specified in the question.