nerdexam
Oracle

1Z0-043 · Question #71

You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?

The correct answer is D. restore the tablespace from the backup and then recover the tablespace; all the redo information. See the full explanation below for the reasoning.

Question

You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?

Options

  • Arestore the tablespace from the backup; there is no need to apply the redo information
  • Brestore the full database to recover the data up to the point when you performed the backup
  • Crestore the tablespace from the backup and then perform a recovery using the backup control file
  • Drestore the tablespace from the backup and then recover the tablespace; all the redo information

How the community answered

(26 responses)
  • A
    12% (3)
  • B
    15% (4)
  • C
    4% (1)
  • D
    69% (18)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice