当前位置: Oracle DBA培训网-优技培训 >> 083题库 >

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

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

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.

技术沙龙MORE+

Oracle技术沙龙:【数据保护顶尖技术-MAA】首次全国首播12c MAA技术 云数据库加上MAA技术组成最豪华的技...
Oracle技术沙龙第49期:【Oracle 数据库云技术分享】Oracle技术沙龙第49期:【Oracle 数据库云技术分享】本次技术沙...
Oracle技术沙龙第48期:【Oracle 12c RAC安装】小编:今天讲什么内容呢?以后有什么用呢? 大师:今天讲的是12c...
我要参加技术沙龙