nerdexam
Oracle

1Z0-067 · Question #221

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a…

The correct answer is C. Tablespace Point-in-Time Recovery D. Flashback Database. See the full explanation below for the reasoning.

Question

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database. Which two best methods are performed the truncated table data? (Choose two.)

Options

  • ATable Point-in-Time Recovery.
  • BDatabase Point-in-Time Recovery
  • CTablespace Point-in-Time Recovery
  • DFlashback Database
  • EFlashback Transaction Backout

How the community answered

(35 responses)
  • A
    9% (3)
  • B
    3% (1)
  • C
    86% (30)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice