Examine this command: Which two statements are true?

The correct answer is B. DML may be performed on tables with one or more extents in this data file during the execution of E. Tables with one or more extents in this data file may be queried during the execution of this. See the full explanation below for the reasoning.

Manage Tablespaces and Datafiles

Question

Examine this command:

Which two statements are true?

Options

ACompressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.
BDML may be performed on tables with one or more extents in this data file during the execution of
CIt overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.
DThe "to" clause containing the new file name must be specified even if Oracle Managed Files
ETables with one or more extents in this data file may be queried during the execution of this

How the community answered

(27 responses)

A
4% (1)
B
70% (19)
C
19% (5)
D
7% (2)

Topics

#MOVE DATAFILE#online operation#datafile management#tablespace

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice