Which two statements are true about resumable space allocation? (Choose two.)
A.
A database-level LOGON trigger can be used to automatically configure resumable statement settings for
individual sessions.
B.
SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.
C.
A resumable statement can be suspended and resumed only once during a session.
D.
Resumable space allocation does not apply when a database instance uses asynchronous commit.
E.
Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.
F.
Free space in a segment is automatically reclaimed when a resumable statement is suspended because of
an out-of-space condition.
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#ADMIN11581
The correct answer should be A and B.
explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#ADMIN11581