Which four actions are possible during an Online Data file Move operation?
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
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 StandbyDatabase is in Active Data Guard Mode. You con use this Command to move the Datafile
– 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. Oracle0 Database Administrator’s Guide 12c Release 1 (12.1)
The correct answers should be ABDF. The following information is copied from another comment posted for the thread of the same question.
The Oracle Database 12c Online Move data file feature provides the capability to move an
online data file from one kind of storage system to another while the database is open and
accessing the file.
This implies that queries, DML and DDL operations can be performed while the data file is
being moved:
• You can create tables and indexes.
• You can rebuild indexes online.
• You can select tables and partitions data.
• If objects are compressed while the data file is moved, the compression remains the
same.
This means that many maintenance operations can be used to move:
• Data files from one kind of storage system to another
• A database into ASM without going down
ADO can benefit from this new enhancement. It allows easy, transparent ADO actions, such as
data movement to other storage tier while tablespaces or data files move to another storage
tier. Associated segments consequently can move to another storage tier.
Compatibilities
NOT compatible with:
• Data file OFFLINE
• Concurrent FLASHBACK
DATABASE operation
• Concurrent media recovery
• data file RESIZE (shrink) operation
Compatible with:
• Block media recovery
• Tablespace made READ ONLY or
READ WRITE
• data file RESIZE (extension)
• Online backup
An Online Move data file operation is not compatible when:
• The data file is an OFFLINE data file
• A concurrent flashback database operation is executing
• A media recovery is completing
• A file shrink operation or tablespace offline/drop operation involving the same file is
performing
But it is compatible with:
• Block media recovery
• ALTER TABLESPACE READ ONLY or READ WRITE operations
• Data file extension operation
• Tablespace/database online backup mode involving the same file
взято из Oracle Database 12c Student Guide vol-1
Base on your information, the answer should be ACDF.
B & E are not correct.
• A concurrent flashback database operation is executing
• A file shrink operation or tablespace offline/drop operation involving the same file is
performing
Yeah I meant to type ACDF. Thanks.