Q3. Examine these queries and their output:
After a system crash, an instance restart and an attempted opening of the PDBs result in:
Which two are true?
- A. Datafile 24 must be recovered while the CDB is opened.
- B. Datafile 24 must be recovered while PDB2 is closed.
- C. Datafile 24 can be recovered while PDB2 is opened.
- D. Datafile 24 cannot be recovered while the CDB is opened.
- E. Datafile 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
Answer: CE
file 24 là của PDB1 chứ ko phải của pdb2 nên có thể thực hiện khi pdb2 đang open
It can be recovered while CDB while PDB2 is opened, as it belongs to PDB1.
the datafile belongs to PDB1 and CAN be recovered while CDB is opened or in mount state.