Oracle Linux 8 System Administration — Question 4

Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quotas? (Choose two.)

Answer options

• A. It allows a role to have unlimited space in any tablespace in the database.
• B. It allows a user to have unlimited space only in their default permanent tablespace.
• C. It allows a user to have unlimited space in any tablespace in the database.
• D. It is overridden by a space quota specified for the user.
• E. By default, users have no quota on their default permanent tablespace.

Correct answer: C, D

Explanation

The correct answers are C and D. Option C is accurate because the UNLIMITED TABLESPACE privilege grants users unlimited space across all tablespaces. Option D is also correct as any space quota defined for a user will take priority over the unlimited privilege, meaning that a user's quota can restrict their usage even if they have the privilege.