Oracle Database 12c: Installation and Administration — Question 39

Which four actions are possible during an Online Data file Move operation? (Choose four.)

Answer options

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

Correct answer: A, C, E, F

Explanation

The correct answers (A, C, E, F) represent actions that can be performed while the data file is being moved, allowing for continuous database operations. Options B and D are incorrect because file shrink and Block Media Recovery are not permitted during the Online Data file Move operation, as they would interfere with the move process.