nerdexam
Oracle

1Z0-074 · Question #21

In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command: FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366; Which action must you perform next?

The correct answer is D. Open HRPDB with RESETLOGS. Explanation/Reference:

Managing Pluggable Databases

Question

In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command:

FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366; Which action must you perform next?

Options

  • AOpen HRPDB
  • BTake a backup of DEPTCDB
  • CTake a backup of HRPDB
  • DOpen HRPDB with RESETLOGS
  • EOpen DEPTCDB with RESETLOGS
  • FOpen DEPTPDB

How the community answered

(42 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    10% (4)
  • D
    81% (34)
  • E
    5% (2)

Explanation

Explanation/Reference:

Topics

#flashback PDB#local undo#RESETLOGS#SCN recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice