Oracle OCP 19c 认证1Z0-083考试题库(第7题)

文章来源：更新时间:2020/12/17 14:00:33

在线老师点击咨询：

最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！

我要咨询

Oracle OCP 19c 认证1Z0-083考试题库(第7题)-CUUG内部学员版083题库解析

7、choose one

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.

You execute the following command to change the requirement:

SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;

What is the outcome?

A) All historical data older than two years, if any, is purged from the flashback archive FDA1.

B) An error is returned because the retention period cannot be reduced.

C) All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.

D) All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Answer ：A

(解析：超过 2 年的老数据将会被从闪回数据归档区删除。闪回数据归档和闪回日志是完全两个独立的概念。)