nerdexam
Oracle

1Z0-083 · Question #66

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? (Choose two.)

The correct answer is A. It can be recovered while CDB while PDB2 is opened, as it belongs to PDB1. C. the datafile belongs to PDB1 and CAN be recovered while CDB is opened or in mount state. Datafile 24 belongs to PDB1.

Perform Backup and Recovery

Question

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? (Choose two.)

Exhibits

1Z0-083 question #66 exhibit 1
1Z0-083 question #66 exhibit 2

Options

  • AIt can be recovered while CDB while PDB2 is opened, as it belongs to PDB1.
  • BData file 24 must be recovered while the CDB is opened.
  • Cthe datafile belongs to PDB1 and CAN be recovered while CDB is opened or in mount state.
  • DData file 24 cannot be recovered while the CDB is opened.
  • EData file 24 must be recovered while PDB2 is closed.

How the community answered

(26 responses)
  • A
    81% (21)
  • B
    4% (1)
  • D
    4% (1)
  • E
    12% (3)

Explanation

Datafile 24 belongs to PDB1.

Topics

#PDB recovery#data file recovery#CDB mount state#multitenant recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice