nerdexam
Oracle

1Z0-043 · Question #104

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?

The correct answer is B. Restore the data file to a new location and perform a media recovery. See the full explanation below for the reasoning.

Question

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?

Options

  • AFlash back all the tables in the data file, one by one.
  • BRestore the data file to a new location and perform a media recovery.
  • CFlash back the database, there is no need to restore the data file.
  • DRestore the data file from the most recent backup and flash the database.

How the community answered

(40 responses)
  • A
    10% (4)
  • B
    83% (33)
  • C
    3% (1)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice