Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

The correct answer is B. A database can be flashed back using SQL*PLUS. E. It always generates REDO and UNDO. F. It requires that the target database be in ARCHIVELOG mode. A is wrong - they are never archived. C is wrong - 19c docs: Queries do not change data and thus do not contribute to logging activity for Flashback Database. D is wrong - according to documentation and my practice some ARCHIVE LOGs are required too.

Configure for Recoverability

Question

Options

AFLASHBACK LOGS are archived after a log switch.
BA database can be flashed back using SQL*PLUS.
CQueries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a
DFLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired
EIt always generates REDO and UNDO.
FIt requires that the target database be in ARCHIVELOG mode.

How the community answered

(23 responses)

A
4% (1)
B
74% (17)
C
4% (1)
D
17% (4)

Explanation

A is wrong - they are never archived. C is wrong - 19c docs: Queries do not change data and thus do not contribute to logging activity for Flashback Database. D is wrong - according to documentation and my practice some ARCHIVE LOGs are required too.

Topics

#Flashback Database#flashback logs#ARCHIVELOG mode#redo and undo

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice