A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?

The correct answer is E. FLASHBACK DATABASE. Backup and Recovery Workshop - typical scenario for Flashback Database is truncate table. You may use FBDA but in different way (not flashing back): insert into t1_recovered select * from t1 as of timestamp sysdate - 1/24;

Configure for Recoverability

Question

Options

AFLASHBACK TRANSACTION
BFLASHBACK VERSION QUERY
CFLASHBACK DATA ARCHIVE
DFLASHBACK TABLE
EFLASHBACK DATABASE

How the community answered

(38 responses)

A
3% (1)
B
8% (3)
C
13% (5)
D
3% (1)
E
74% (28)

Explanation

Backup and Recovery Workshop - typical scenario for Flashback Database is truncate table. You may use FBDA but in different way (not flashing back): insert into t1_recovered select * from t1 as of timestamp sysdate - 1/24;

Topics

#Flashback Database#truncate recovery#flashback feature selection#data recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice