Exam 1z0-082 topic 1 question 148 discussion

E - is correct Typically this scenario occurs when a user reaches the limit of his/her COTA on the tablespace in which he/she is performing an operation that requires space allocation (ORA-01536) or when his/her tablespace reaches its maximum size, making it impossible for any user to allocate space (ORA-01652).

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.

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.