Oracle Database Administration I — Question 126

Which three statements are true about Resumable Space Allocation in Oracle databases? (Choose three.)

Answer options

• A. A user's session may be suspended and resumed multiple times.
• B. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
• C. All sessions must have the same timeout value when waiting for resumable space allocations.
• D. Resumable space allocation is only possible with locally managed tablespaces.
• E. A user's session may be suspended even if the user has the UNLTMTTED TABLESPACE system privilege.
• F. Resumable space allocation may be enabled for some sessions and not others.

Correct answer: A, E, F

Explanation

The correct answers A, E, and F highlight the flexibility and limitations of Resumable Space Allocation. A states that sessions can be suspended multiple times, E clarifies that having the UNLTMTTED TABLESPACE privilege does not prevent suspension, and F indicates that not all sessions need to have resumable space allocation enabled. Options B, C, and D present inaccuracies regarding the triggers and constraints of this feature.