Chinaunix首页 | 论坛 | 博客
  • 博客访问: 672713
  • 博文数量: 487
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 4936
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59
个人简介

ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291

文章分类

全部博文(487)

文章存档

2024年(2)

2023年(37)

2021年(151)

2020年(37)

2019年(222)

2018年(38)

我的朋友

分类: Oracle

2021-03-01 14:31:00

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

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.

阅读(1481) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~