Examine this command: Which two statements are true? (Choose two.)

The correct answer is A. DML may be performed on tables with one or more extents in this data file during the execution of B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the. See the full explanation below for the reasoning.

Manage Tablespaces and Datafiles

Question

Examine this command:

Which two statements are true? (Choose two.)

Options

ADML may be performed on tables with one or more extents in this data file during the execution of
BThe tablespace containing SALES1.DBF must be altered READ ONLY before executing the
CThe tablespace containing SALES1.DBF must be altered OFFLINE before executing the
DIf Oracle Managed Files (OMF) is used, then the file is renamed but moved to
EThe file is renamed and stored in the same location

How the community answered

(42 responses)

A
69% (29)
C
17% (7)
D
5% (2)
E
10% (4)

Topics

#datafile rename#tablespace READ ONLY#Oracle Managed Files#datafile relocation

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice