1Z0-083 practice question 23 of 35

Choose the best. Examine this configuration:1. CDB1 is a container database.2. There are several pluggable databases (PDBs) in CDB1.5. Each PDB has…

Full set: 286 questions

Choose the best. Examine this configuration:

1. CDB1 is a container database.

2. There are several pluggable databases (PDBs) in CDB1.

5. Each PDB has several tables with referential integrity constraints.

6. FLASHBACK DATABASE is ON.

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

A. restore and recover database

B:

B. flashback transaction

C:

C. flashback database

Correct answer
D:

D. flashback table and transaction

E:

E. flashback table

Correct Answer:
C. C. flashback database
Explanation

The scenario describes widespread, undesired changes across multiple tables in all PDBs of a container database (CDB). The FLASHBACK DATABASE command is the only option that can revert the entire CDB, including all its PDBs, to a specific point in time with a single command. This operation is efficient and addresses the problem at the required scope (the entire container). The prerequisites, such as FLASHBACK DATABASE being enabled, are met. This method correctly and holistically undoes the changes across all affected PDBs simultaneously.

Why Incorrect

A. Restore and recover is a media recovery process, not a logical flashback. It is more complex than a single command and is overkill for this scenario.
B. Flashback Transaction targets specific transactions. Undoing changes in all PDBs would require identifying and flashing back numerous transactions individually.
D. This is not a single command. It would involve multiple FLASHBACK TABLE and/or FLASHBACK TRANSACTION commands.
E. Flashback Table operates on individual tables. It would require many commands and would not automatically handle referential integrity between tables.

References

Oracle Database Backup and Recovery User's Guide, 19c, Chapter 16, "Performing Flashback and Database Point-in-Time Recovery".

Section "Flashback Database in a Multitenant Environment" states: "In a multitenant environment, the FLASHBACK DATABASE command operates on the whole CDB. You cannot perform a flashback database operation on an individual PDB." This confirms it is the correct tool for a CDB-wide rollback.

Scroll to Top