Upgrade to Oracle Database 12c — Question 7

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:

SQL > SHUTDOWN IMMEDIATE -

SQL > STARTUP MOUNT -
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12','MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashed back schema?

Answer options

• A. Only 1
• B. Only 2
• C. Only 3
• D. 3 and 1
• E. 1 and 2

Correct answer: D

Explanation

To allow updates to the flashed back schema, you need to open the PDBs and the CDB database. Executing 'ALTER PLUGGABLE DATABASE ALL OPEN;' (command 1) opens all PDBs, while 'ALTER DATABASE OPEN RESETLOGS;' (command 3) is necessary to reset the logs after a flashback operation. Therefore, both commands 1 and 3 are required, making option D the correct choice.