Which four actions are possible during an Online Data file Move operation?

Question

Options

• ACreating and dropping tables in the data file being moved
• BPerforming file shrink of the data file being moved
• CQuerying tables in the data file being moved
• DPerforming Block Media Recovery for a data block in the data file being moved
• EFlashing back the database
• FExecuting DML statements on objects stored in the data file being moved

• A
  77% (27)
• B
  14% (5)
• D
  9% (3)

Explanation

You can now move On line Datafile without hove to stop Monoged Recovery and manually copy and rename Files. This can even be used to move Datafiles from or to ASM. - New in Oracle Database 12c: FROM METAUNK. Physical Standby Database is in Active Data Guard Mode (opened READ ONLY and Managed Recovery is running): It is now possible to online move a Datafile while Managed Recovery is running, ie. the Physical Standby Database is in Active Data Guard Mode. You con use this Command to move the - A flashback operation does not relocate a moved data file to its previous location. If you move a data file online from one location to another and later flash back the database to a point in time before the move, then the Data file remains in the new location, but the contents of the Data file ore changed to the contents at the time specified in the flashback.

No community discussion yet for this question.