ocp-28

QUESTION NO: 28
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task,
you enabled Flashback Data Archive with the retention of 5 years. After some time, the business
requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish
this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

What is the implication of this command?
A. The command produces an error because the retention time cannot be reduced.
B. All historical data is retained but the subsequent flashback data archives are maintained for only three
years.
C. All historical data is purged and the new flashback data archives are maintained for three years.
D. All historical data older than three years is purged from the flashback archive FLA1. 所有三年以
上的历史数据从FLA1闪回归档中清除
Answer: D

---

你想跟踪并存储在其生命周期内的所有事务的变化到一个表。要完成这个任务，你启用了5年保留的闪回数据归档。一段时间后，业务需求变化，你被要求更改保留从5年
到3年。要做到这一点，你发出以下命令：
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
改变闪回归档FLA1修改保留3年;
这个命令的含义是什么？
D.所有三年以上的历史数据从FLA1闪回归档中清除

---