Which three statements are true about using flashback database in a multitenant container
database (CDB)?
A.
The root container can be flashed back without flashing back the pluggable databases (PDBs).
B.
To enable flashback database, the CDB must be mounted.
C.
Individual PDBs can be flashed back without flashing back the entire CDB.
D.
The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of
the CDB.
E.
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a
restore point.
Explanation:
B: to enable flashback database, cdb can be either open/mounted… But cdb need be mounted if you need flashback database…
D: DB_FLASHBACK_RETENTION_TARGET has default value… so it’s not necessary to be set and only set it cannot enable flashback I think…
E: you can flashback to a restore point e.g.FLASHBACK DATABASE TO RESTORE POINT ‘before_upgrade’;
So…there is no correct ans
Exactly, the questions are tough for the wrong reason!
I would choose ABD.
Flashback database is not applicable to PDB so choice A is somewhat correct.
Ref: http://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV603
Root container can be flashed back without flashing back PDB.
Option B need to be specified more clearly.
It is either we can enable flashback feature in database in mount and open mode then correct
but if we need to flashback database then that could be done only in mount mode.
http://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV595
Option D is correct
So answer is A, B, D
A D E
A B D