Which two actions would enable resumable space allocation at the instance level?

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.)

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

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *