45 You want to disable resumable space allocation for all sessions. Which value should be assigned t

QUESTION 45
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

.

。

。

。

。

。

。

。

Correct Answer: A
Section: (none)
Explanation

Explanation/Reference:

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