Oracle Database 12c: Advanced Administration — Question 21

Which three statements are true about Flashback Data Archive?

Answer options

• A. Flashback Data Archive prevents flashback queries from getting a snapshot too-old error.
• B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
• C. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.
• D. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
• E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

Correct answer: C, D, E

Explanation

The correct statements (C, D, E) highlight the requirements and functionality of Flashback Data Archive. Option C is accurate because a default archive is required for enabling it on a table, D is correct as it specifies the naming behavior when enabling the archive, and E is true since users need sufficient quota. Options A and B, however, are incorrect as they misrepresent the conditions and limitations related to Flashback Data Archive.