OCP-1Z0-053-200题-153题-211

QUESTION 153

You want to disable resumable space allocation for all sessions.

Which value should be assigned to the RESUMABLE_TIMEOUTparameter to disable resumable space

allocation for all sessions?

A. 0

B. 10

C. 100

D. NULL

Answer: A

同211题：http://blog.csdn.net/rlhua/article/details/14452957

Explanation/Reference:

Section: Database Architecture & Resource Management, RAC, ASM

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 resumablestatement 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, anda value

of 100 indicates 100 seconds.

The NULL value is an invalid value to be assigned to the RESUMABLE_TIMEOUT parameter.