Oracle Database 12c: Advanced Administration — Question 57

Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years.
Three years later, it is decided to change the retention period.
You execute this command:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;
Which is true?

Answer options

• A. An error is returned because the retention period cannot be reduced.
• B. Data from the first and third years is purged from the flashback archive FDA1.
• C. Flashback archive FDA1 retains all data and the retention period is increased by 2 years.
• D. Data older than two years, if any, is purged from the flashback archive FDA1.
• E. Data from the third year is purged from the flashback archive FDA1.

Correct answer: C

Explanation

The correct answer is C because modifying the retention period to a longer duration allows the archive to continue retaining all data without purging any existing data. The other options are incorrect as they either imply an error in the command or suggest data purging that does not occur when extending the retention period.