exam questions

Exam 1z0-053 All Questions

View all questions & answers for the 1z0-053 exam

Exam 1z0-053 topic 11 question 35 discussion

Actual exam question from Oracle's 1z0-053
Question #: 35
Topic #: 11
[All 1z0-053 Questions]

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

  • A. The time when the last flashback operation in your database was performed
  • B. The time when the first flashback operation in your database was performed
  • C. The approximate time and the lowest system change number (SCN) to which you can flash back your database
  • D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...