Oracle Database 12c Advance Adminstration1z0-063 Test 4

Question : 24 of 40

Marks: +1, -0

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?

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

Validate

Go to Question:

Prev Question

Next Question