208.You want to enable resumable space allocation at the instance 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
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN11589
Setting the RESUMABLE_TIMEOUT Initialization Parameter
You can specify a default system wide timeout interval by setting the RESUMABLE_TIMEOUT initialization parameter. For example, the following setting of theRESUMABLE_TIMEOUT parameter in the initialization
parameter file sets the timeout period to 1 hour:
If this parameter is set to 0, then resumable space allocation is disabled even for sessions that run an ALTER SESSION ENABLE RESUMABLE statement without a timeout value.
You can also use the ALTER SYSTEM SET statement to change the value of this parameter at the system level. For example, the following statement disables resumable space allocation for all sessions that run an ALTER
SESSION ENABLE RESUMABLE statement without a timeout value:
| Modifiable | ALTER SESSION, ALTER SYSTEM |
RESUMABLE_TIMEOUT enables or disables resumable statements and specifies resumable timeout at the system level.