Oracle Database 12c: Installation and Administration — Question 250

Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.) (Choose three.)

Answer options

• 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.

Correct answer: A, B, D

Explanation

Option A is correct because the root container can indeed be flashed back independently of the PDBs. Option B is also correct as the CDB must be mounted for flashback operations. Option D is correct since the DB_FLASHBACK RETENTION_TARGET must be set to enable flashback capabilities. Options C and E are incorrect because they misrepresent the functionality of flashback in a CDB context.