44 You want to enable resumable space allocation at the instance level. Which two actions would enab

44
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

Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
Explanation:
You can enable resumable space allocation at the instance level by modifying the
RESUMABLE_TIMEOUT initialization parameter to a nonzero value, or you can 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.