OCP-1Z0-053-200题-154题-208

QUESTION 154

You want to enable resumable space allocation at theinstance level.

Which two actions would enable resumable space allocation at the instance level? (Choose two.)

A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement

B. issuing the ALTER SESSION ENABLE RESUMABLE; statement

C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>;statement

Answer: CD

同208题：http://blog.csdn.net/rlhua/article/details/14452683

Explanation/Reference:

Section: Database Architecture & Resource Management, RAC, ASM

You can enable resumable space allocation at the instance level by modifying the RESUMABLE_TIMEOUT

initialization parameter to a nonzero value, or youcan change the value of the RESUMABLE_TIMEOUT

parameter dynamically by issuing the following statement:

ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero_value>;

Issuing the ALTER SYSTEM ENABLE RESUMABLE;statement is incorrect. This statement would generate an

error on execution because the syntax is incorrect.

Issuing the ALTER SESSION ENABLE RESUMABLE;statement is incorrect. You issue the ALTER SESSION

ENABLE RESUMABLE;statement to enable resumable space allocation at the session level, not to enable

resumable space allocation at the instance level.