Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

The correct answer is B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be D. Row Movement must be enabled on the table being flashed back. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/FLASHBACK- TABLE.html#GUID-FA9AF2FD-2DAD-4387-9E62-14AFC26EA85C

Perform Backup and Recovery

Question

Options

AA table's constraints must be disabled before issuing the flashback.
BThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be
CA table's indexes must be set to unusable before issuing the flashback.
DRow Movement must be enabled on the table being flashed back.
EThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be

How the community answered

(36 responses)

A
6% (2)
B
81% (29)
C
11% (4)
E
3% (1)

Explanation

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/FLASHBACK- TABLE.html#GUID-FA9AF2FD-2DAD-4387-9E62-14AFC26EA85C

Topics

#Flashback Table#row movement#FLASHBACK privilege#undo retention

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice