ocp 19c考題，科目082考試題(15)-move datafile to

15.Examine this command:

ALTER DATABASE

MOVE DATAFILE '/u01/sales1.dbf'

TO /u01/sales01.dbf'

REUSE;

Which two statements are true? (Choose two.)

A. DML may be performed on tables with one or more extents in this data file during the execution of this command.

B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

E. The file is renamed and stored in the same location

source : cuug