Oracle
1Z0-062 · Question #106
1Z0-062 Question #106: Real Exam Question with Answer & Explanation
The correct answer is D: 3 and 1. After a FLASHBACK DATABASE operation on a CDB, the database must be opened with RESETLOGS to establish a new redo incarnation, then PDBs must be explicitly opened to allow DML.
Question
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 flashback back schema?Options
- AOnly 1
- BOnly 2
- COnly 3
- D3 and 1
- E1 and 2
Explanation
After a FLASHBACK DATABASE operation on a CDB, the database must be opened with RESETLOGS to establish a new redo incarnation, then PDBs must be explicitly opened to allow DML.
Common mistakes.
- A. ALTER PLUGGABLE DATABASE ALL OPEN alone is insufficient because the CDB itself must first be opened with RESETLOGS after a FLASHBACK DATABASE operation before PDBs can be opened.
- B. ALTER DATABASE OPEN without the RESETLOGS clause is not valid after FLASHBACK DATABASE; Oracle requires RESETLOGS because the redo log sequence has changed.
- C. ALTER DATABASE OPEN RESETLOGS alone opens the CDB but leaves all PDBs in MOUNTED state, preventing any user access or DML against the PDB schema.
- E. Commands 1 and 2 bypass the required RESETLOGS clause; ALTER DATABASE OPEN without RESETLOGS is rejected by Oracle after a flashback, making this combination invalid.
Concept tested. Flashback Database open sequence in multitenant CDB
Community Discussion
No community discussion yet for this question.