Which three statements are true about Resumable Space Allocation in Oracle databases? (Choose three.)
Which three statements are true about Resumable Space Allocation in Oracle databases? (Choose three.)
A user's session may indeed be suspended and resumed multiple times due to the nature of Resumable Space Allocation. The privilege of having UNLIMITED TABLESPACE does not prevent a session from being suspended; the allocation is more about space management within the tablespaces. It is possible to enable Resumable Space Allocation for individual sessions rather than needing it to be a universal setting across all sessions. These statements accurately reflect the behavior and capabilities of Resumable Space Allocation within Oracle databases.
Resumable Space Allocation is possible also with Dictionary Managed Tablespaces; with some limitations, but possible, so D is false. There is nothing that indicates that UNLIMITED TABLESPACE privilege can avoid the Resumable Space Allocation, so E is true. Also, A and F are correct.
A - true, "A resumable statement can be suspended and resumed multiple times during execution." B - false, "SQL statements executed within a AFTER SUSPEND trigger are always non-resumable and are always autonomous." C - false, ALTER SESSION SET RESUMABLE_TIMEOUT sets specific timeout for the session it is executed in, it does not affect other sessions D - false, "There are two ways to specify alert thresholds for both locally managed and dictionary managed tablespaces:" E - true, there is no notice about UNLIMITED TABLESPACE in documentation claiming this system privilege prevents raising Resumable Space Allocation event F - true, ALTER SESSION ENABLE RESUMABLE can be executed in some sessions and it is not necessary to run it in all sessions
Correct answer in my opinion.
I also think that AEF a correct, but I find this statement in a book... "If you create an AFTER SUSPEND ON DATABASE trigger that attempts to fix problems, remember that it might hit a space problem itself." Watson, John; Watson, John. OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062) (Oracle Press) . McGraw Hill LLC. Kindle Edition.
The expression in option B, "may be suspended," suggests that the trigger may not function properly due to resource deficiencies. Therefore, interpreting "suspended" in this context as the trigger being unable to operate as intended seems reasonable. Thus, in this light, option B can be considered correct as it acknowledges that the trigger may not perform effectively due to space limitations.