You want to execute the following statements in resumable mode:
CREATE TABLE … AS SELECT
CREATE INDEX
CREATE MATERIALIZED VIEW
Which two methods can be used to enable a session for resumable space allocation?
(Choose two.)
A.
Set the RESUMABLE_TIMEOUT initialization parameter to true.
B.
Set the RESUMABLE_TIMEOUT initialization parameter to a nonzero value.
C.
Execute the ALTER SESSION ENABLE RESUMABLE statement.
D.
Execute the ALTER DATABASE ENABLE RESUMABLE statement.
E.
Set the RESUMABLE_TIMEOUT initialization parameter to none.
Explanation: