Oracle Database 12c: Advanced Administration — Question 121

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 during an Online Datafile Move operation include creating and dropping tables, querying tables, flashing back the database, and executing DML statements. Performing file shrink and Block Media Recovery are not permitted while the datafile is being moved, which makes options B and D incorrect.