Oracle Database 12c: Installation and Administration — Question 176

Which two statements are true about resumable space allocation? (Choose two.)

Answer options

• 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.

Correct answer: A, B

Explanation

Option A is correct because a database-level LOGON trigger can indeed configure resumable settings for sessions. Option B is also correct as SELECT statements that run out of temporary space can utilize resumable execution. The other options either misstate the behavior of resumable space allocation or describe scenarios where it does not apply.