Which three statements are true about resumable space allocation in Oracle databases? (Choose three.)
A
All sessions must have the same timeout value when waiting for resumable space allocations.
B
The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
C
Resumable space allocation is only possible with locally managed tablespaces.
D
A user’s session may be suspended and resumed multiple times.
E
A user’s session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.
F
Resumable space allocation may be enabled for some sessions and not others.
Show Answer
