Which two statements are true about resumable space allocation?

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.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.