Oracle
1Z0-062 · Question #293
Which two statements are true about resumable space allocation? (Choose two.)
The correct answer is B. SELECT statements that run out of temporary space for sort areas are candidates for resumable C. A resumable statement can be suspended and resumed only once during a session. https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#ADMIN11581
Managing Database Storage Structures
Question
Which two statements are true about resumable space allocation? (Choose two.)
Options
- AA database-level LOGON trigger can be used to automatically configure resumable statement settings
- BSELECT statements that run out of temporary space for sort areas are candidates for resumable
- CA resumable statement can be suspended and resumed only once during a session.
- DResumable space allocation does not apply when a database instance uses asynchronous commit.
- EResumable space allocation does not apply when users exceed their assigned space quota in a
- FFree space in a segment is automatically reclaimed when a resumable statement is suspended because
How the community answered
(21 responses)- A10% (2)
- B86% (18)
- D5% (1)
Explanation
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#ADMIN11581
Topics
#resumable space allocation#space management#temporary tablespace
Community Discussion
No community discussion yet for this question.