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.