Oracle Database Administration II — Question 152

Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
3. Each PDB has several tables with referential integrity constraints.
4. FLASHBACK DATABASE is ON.
5. UNDO RETENTION GUARANTEE is enabled.

Multiple undesired multitable changes were made in all the PDBs.

Which method can be used to undo the changes using a single command?

Answer options

• A. restore and recover database
• B. flashback transaction
• C. flashback database
• D. flashback table
• E. flashback table and transaction

Correct answer: C

Explanation

The correct answer is C, as FLASHBACK DATABASE allows you to revert the entire database to a specific point in time, effectively undoing all changes across all PDBs. Options A and B do not provide a single command for all databases, while D and E focus on specific tables or transactions, which is not suitable for the scenario of multiple table changes.