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 questionsChoose 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?
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.
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.
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.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
