Exam 1z0-063 topic 1 question 56 discussion

Actual exam question from Oracle's 1z0-063

Question #: 56
Topic #: 1

[All 1z0-063 Questions]

In which situation can you use Flashback Database?

A. when undoing a shrink data file operation
B. when retrieving a dropped tablespace
C. when returning to a point in time before the restoration or re-creation of a control file
D. when returning to a point in time before the most recent open resetlogs operation

Show Suggested Answer

Suggested Answer: B 🗳️
Reference:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm
(prerequisites, third para)
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194

by Jake at June 4, 2019, 3 p.m.

Comments

Submit Cancel

Jake

Highly Voted 6 years, 2 months ago

The answer is D You cannot FLASHBACK DATABASE for individual tablespaces. In the Semantic portion, " FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later."

upvoted 5 times

...

Abby_

Most Recent 3 years, 6 months ago

D is the right answer. "You can use Flashback Database to reverse most unwanted changes to a database if the data files are intact. You can return a database to its state in a previous incarnation, and undo the effects of an ALTER DATABASE OPEN RESETLOGS statement." Reference: https://docs.oracle.com/cd/E11882_01/backup.112/e10642/flashdb.htm#BRADV583

upvoted 2 times

...

Sugar

5 years, 2 months ago

Yes D is the answer

upvoted 3 times

...

sherifelia

5 years, 6 months ago

Answer is D

upvoted 3 times

...