Which two methods can be used to enable a session for resumable space allocation?

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

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:



Leave a Reply 0

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