Oracle Database Administration II — Question 139

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

Answer options

• A. FLASHBACK TRANSACTION
• B. FLASHBACK VERSION QUERY
• C. FLASHBACK DATA ARCHIVE
• D. FLASHBACK TABLE
• E. FLASHBACK DATABASE

Correct answer: C

Explanation

The correct answer is FLASHBACK DATA ARCHIVE, which is specifically designed for recovering data that has been modified or deleted. The other options, such as FLASHBACK TABLE, are used for different types of recovery, and FLASHBACK TRANSACTION and FLASHBACK VERSION QUERY do not directly help in recovering truncated data.