Multiple choice

JOE was allocated 10 MB of quota in the USERS tablespace. He created database objects in the USERS tablespace. The total space allocated for the objects owned by JOE is 5 MB. In order to revoke JOE's quota from the USERS tablespace, the following command was issued. ALTER USER JOE QUOTA 0 ON users; What will be the result?

  1. The statement raises the error: ORA-00940: invalid ALTER command.

  2. The statement raises the error: ORA-00922: missing or invalid option.

  3. The objects owned by JOE are automatically deleted from the revoked USERS tablespace.

  4. The objects owned by JOE remain in the revoked tablespace, but these objects cannot be allocated any new space from the USERS tablespace.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When a user's tablespace quota is revoked by setting it to 0, existing objects owned by that user are not automatically dropped, moved, or otherwise affected. The objects remain in the tablespace occupying their current space. However, the user cannot allocate any additional space from that tablespace for new objects or for extending existing ones. This behavior ensures existing data isn't lost while preventing future space consumption. The quota change affects only future allocations, not existing storage.

Keep practicing — related questions