What three are true about Oracle Flashback technology? (Choose three.)

The correct answer is A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction. C. FLASHBACK DATABASE can be used to rewind a database back and forth in time. D. FLASHBACK TABLE can be used to undo dropping a column from a table. See the full explanation below for the reasoning.

Question

What three are true about Oracle Flashback technology? (Choose three.)

Options

AFLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
BFLASHBACK TABLE can be used to rewind a table back in time.
CFLASHBACK DATABASE can be used to rewind a database back and forth in time.
DFLASHBACK TABLE can be used to undo dropping a column from a table.
EFLASHBACK QUERY can be used to view committed data at any given point in time.

How the community answered

(45 responses)

A
73% (33)
B
11% (5)
E
16% (7)

Community Discussion

No community discussion yet for this question.

Full 1Z0-072 Practice