ocp-28
来源:互联网 发布:淘宝网商家服务热线 编辑:程序博客网 时间:2024/05/05 10:54
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闪回归档中清除
- ocp-28
- ocp
- ocp
- OCP
- Ocp
- OCP
- ocp
- OCP
- ocp
- OCP 1Z0 051 28
- OCP 1Z0 052 28
- OCP 1Z0 053 28
- OCP 1Z0 051 QUESTION NO: 28
- OCP-1Z0-051-2015-28题
- Oracle OCP笔记(28)RMAN备份 - Catalog
- OCP-1Z0-052-V8.02-28题
- OCP-1Z0-051-V9.02-28题
- OCP-1Z0-新051-61题版本-28
- [摘要]Effective Objective-C 2.0(二)
- Android中数据库的创建与增删改查操作
- 意图(Intent)讲解2:安卓使用意图(Intent)传递数据并返回结果
- 骑车与走路
- ocp-27
- ocp-28
- guava中扩展容器的一些常用类和方法(二)
- ocp-29
- 轮船渡口管理 C++版
- ocp-30
- Mysql 列转行统计查询 、行转列统计查询
- C/C++中的转义字符 (普通转义字符、八进制转移字符及十六进制转义字符)
- 关于python的学习
- java中根类Object包含的方法和类成员访问权限