You executed the following query: 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 our 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
https://docs.oracle.com/database/121/REFRN/GUID-4DFB54C5-271D-41D9-AEE5-7389BB219544.htm#REFRN30300
OLDEST_FLASHBACK_SCN: Lowest system change number (SCN) in the flashback data, for any incarnation
OLDEST_FLASHBACK_TIME: Time of the lowest SCN in the flashback data, for any incarnation
From https://docs.oracle.com/database/121/RCMRF/rcmsynta023.htm#RCMRF194 :
Query OLDEST_FLASHBACK_SCN in V$FLASHBACK_DATABASE_LOG to see the approximate lowest SCN to which you can flash back.
This metric returns the oldest point-in-time to which you can flashback your database.
This is a database-level metric. For cluster databases, this metric is monitored at the cluster database target level and not by member instances.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-062 Exam Questions
Log in to ExamTopics
Sign in:
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.
Ray520
3 years agoNorwayOracle
3 years, 1 month agoNorthKorean
5 years, 2 months ago