Which two are true about Oracle Flashback features? (Choose two.)

The correct answer is D. FLASHBACK DROP can undrop an index when undropping a table. E. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it. A & B are wrong, because flashback use undo not redo/archive. Not C because flashback table cannot rever ddl D & E are correct -> as of before drop retrieve from the recycle bin also the related index, and after using flashback database command, sometimes you could go forward…

Configure for Recoverability

Question

Options

AFLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG
BFLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED
CFLASHBACK TABLE can undrop a column.
DFLASHBACK DROP can undrop an index when undropping a table.
EAfter a database is restored from flashback logs using the FLASHBACK DATABASE command, it

How the community answered

(26 responses)

A
4% (1)
B
8% (2)
C
19% (5)
D
69% (18)

Explanation

A & B are wrong, because flashback use undo not redo/archive. Not C because flashback table cannot rever ddl D & E are correct -> as of before drop retrieve from the recycle bin also the related index, and after using flashback database command, sometimes you could go forward with redo.

Topics

#Flashback Drop#Flashback Database#Flashback Query#Flashback Table

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice