Which statement about Online Move Data file is true?

Which statement about Online Move Data file is true?

Which statement about Online Move Data file is true?

A.
Moving a data file online prevents DML operations on segments stored in the data file.

B.
Flashing back a database to a point in time before a data file had been renamed online retains
the new name.

C.
Moving a data file online can be performed if the data file is in OFFLINE mode.

D.
Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


reed

reed

true B

“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 are changed to the contents at the time specified in the flashback. See Oracle Database Backup and Recovery User’s Guide for more information about flashback database operations.”
http://docs.oracle.com/database/121/ADMIN/dfiles.htm#ADMIN012