Upgrade Oracle DBA 11g to Oracle Database 12c — Question 19

Which four actions are possible during an Online Datafile Move operation?

Answer options

• A. Creating and dropping tables in the datafile being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the datafile being moved
• D. Performing Block Media Recovery for a data block in the datafile being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the datafile being moved

Correct answer: A, C, E, F

Explanation

The correct actions A, C, E, and F can be performed during an Online Datafile Move operation because they do not interfere with the file's movement. Options B and D are incorrect as they involve altering the datafile's structure or content, which are not permitted while the move is taking place.