nerdexam
Oracle

1Z0-032 · Question #37

You are using Recovery Manager (RMAN) to maintain daily backups of your database, which is running in ARCHIVELOG mode. In which two scenarios would you perform an incomplete database recovery using…

The correct answer is A. when a table is dropped B. when a table is truncated. Oracle 1Z0-032 Exam

Backup and Recovery

Question

You are using Recovery Manager (RMAN) to maintain daily backups of your database, which is running in ARCHIVELOG mode. In which two scenarios would you perform an incomplete database recovery using UNTIL TIME from the backups that you maintain using RMAN? (Choose two.)

Options

  • Awhen a table is dropped
  • Bwhen a table is truncated
  • Cwhen the SYSTEM tablespace is corrupted
  • Dwhen the data block in a nonsystem tablespace is corrupted
  • Ewhen a data file that belongs to a nonsystem tablespace is corrupted

How the community answered

(53 responses)
  • A
    83% (44)
  • C
    2% (1)
  • D
    11% (6)
  • E
    4% (2)

Explanation

Oracle 1Z0-032 Exam

Topics

#RMAN#incomplete recovery#UNTIL TIME#point-in-time recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice