nerdexam
Oracle

1Z0-043 · Question #122

You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?

The correct answer is D. The approximate time and the lowest system change number (SCN) to which you can flash back. See the full explanation below for the reasoning.

Question

You executed the following query in your database:

SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?

Options

  • AThe time when the last flashback operation in your database was performed.
  • BThe time when the first flashback operation in your database was performed.
  • CA list of flashback operations performed in your database using SCN and time.
  • DThe approximate time and the lowest system change number (SCN) to which you can flash back

How the community answered

(21 responses)
  • A
    5% (1)
  • B
    10% (2)
  • C
    5% (1)
  • D
    81% (17)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice