Choose the best answer. 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?
You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)
Choose the best answer. Examine this configuration: 1. CDB1 is a container database running in ARCHIVELOG mode. 2. Multiple uncommitted transactions are running in CDB1. 3. Redo log groups 1 and 2 are INACTIVE. 4. Redo log group 3 is the CURRENT group All members of redo log group 3 are lost before it is archived. Examine these possible steps: 1. SHUTDOWN ABORT 2. STARTUP NOMOUNT 3. STARTUP MOUNT 4. ALTER DATABASE MOUNT 5. RESTORE DATABASE 6. RECOVER DATABASE NOREDO 7. RECOVER DATABASE UNTIL AVAILABLE 8. RESTORE ARCHIVELOG ALL 9. ALTER DATABASE OPEN 10. ALTER DATABASE OPEN RESETLOGS Choose the minimum required steps in the correct order to recover the database.