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.