nerdexam
Oracle

1Z0-067 · Question #122

Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?

The correct answer is B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to E. Enable Fast Recovery Area. https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582 Section: About Flashback Database Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area. You can only use Flashback Database if flashback logs are…

New Features for Availability

Question

Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?

Options

  • AEnable minimal supplemental logging.
  • BEnsure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to
  • CEnable the recyclebin.
  • DEnable undo retention guarantee.
  • EEnable Fast Recovery Area.

How the community answered

(38 responses)
  • A
    5% (2)
  • B
    79% (30)
  • C
    13% (5)
  • D
    3% (1)

Explanation

https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582 Section: About Flashback Database Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area. You can only use Flashback Database if flashback logs are available. To take advantage of this feature, you must set up your database in advance to create flashback

Topics

#Flashback Database#Fast Recovery Area#db_flashback_retention_target#prerequisites

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice