Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?

You want to disable resumable space allocation for all sessions.
Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable
space allocation for all sessions?

A.
0

B.
10

C.
100

D.
NULL

Explanation:
You can disable resumable space allocation for all sessions by assigning a value of 0 to the
RESUMABLE_TIMEOUT parameter. The RESUMABLE_TIMEOUT parameter indicates the
maximum time that a resumable statement is suspended. A resumable statement can be a data
definition language (DDL) command that is being suspended due to non-availability of space
allocated for the object to be created in the database. After the space is allocated, the suspended

statement can be resumed for execution. You can also disable resumable space allocation for a
single session using the ALTER SESSION DISABLE RESUMABLE; statement within the session.
The values 10 and 100 can be assigned to the RESUMABLE_TIMEOUT parameter, but these
values cannot be used to disable resumable space allocation for all sessions. A value of 10
indicates 10 seconds, and a value of 100 indicates 100 seconds. The NULL value is an invalid
value to be assigned to the RESUMABLE_TIMEOUT parameter.
Topic 5, Pool 5