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.
C is correct answer
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
upvoted 4 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
guru_ji
1 year, 6 months agokushan8825
1 year, 10 months agoamacias
2 years, 9 months agoKoolt
3 years, 7 months ago