OCP-1Z0-053-V13.02-25题
来源:互联网 发布:js鼠标事件有哪些 编辑:程序博客网 时间:2024/05/29 08:03
25.You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on
the table after enabling Flashback Data Archive?
A. Drop the table.
B. Partition the table
C. Truncate the table.
D. Add a column to the table.
E. Rename a column in the table.
DDL Statements on Tables Enabled for Flashback Data Archive
Flashback Data Archive supports only these DDL statements:
ALTER
TABLE
statement that does any of the following:Adds, drops, renames, or modifies a column
Adds, drops, or renames a constraint
Drops or truncates a partition or subpartition operation
TRUNCATE
TABLE
statementRENAME
statement that renames a table
Flashback Data Archive does not support DDL statements that move, split, merge, or coalesce partitions or subpartitions, move tables, or convert LONG
columns to LOB
columns.
For example, the following DDL statements cause error ORA-55610 when used on a table enabled for Flashback Data Archive:
ALTER
TABLE
statement that includes anUPGRADE
TABLE
clause, with or without anINCLUDING
DATA
clauseALTER
TABLE
statement that moves or exchanges a partition or subpartition operationDROP
TABLE
statement
If you must use unsupported DDL statements on a table enabled for Flashback Data Archive, use theDBMS_FLASHBACK_ARCHIVE
.DISASSOCIATE_FBA
procedure to disassociate the base table from its Flashback Data Archive. To reassociate the Flashback Data Archive with the base table afterward, use the DBMS_FLASHBACK_ARCHIVE
.REASSOCIATE_FBA
procedure.
根据官方文档,此题可选CDE,可根据D50081CN11文档,只能选D,且没有提到C是否支持。
综合一下,如果考试时单选则选D,如果多选则选CDE
- OCP-1Z0-053-V13.02-25题
- OCP-1Z0-053-V13.02-25题
- OCP-1Z0-053-V13.02-1题
- OCP-1Z0-053-V13.02-682题
- OCP-1Z0-053-V13.02-687题
- OCP-1Z0-053-V13.02-692题
- OCP-1Z0-053-V13.02-696题
- OCP-1Z0-053-V13.02-711题
- OCP-1Z0-053-V13.02-710题
- OCP-1Z0-053-V13.02-709题
- OCP-1Z0-053-V13.02-708题
- OCP-1Z0-053-V13.02-706题
- OCP-1Z0-053-V13.02-490题
- OCP-1Z0-053-V13.02-24题
- OCP-1Z0-053-V13.02-36题
- OCP-1Z0-053-V13.02-43题
- OCP-1Z0-053-V13.02-45题
- OCP-1Z0-053-V13.02-60题
- virtual void runThisTest() = 0;是什么意思
- 产品生成信息表的数据迁移
- Oracle DBA面对全新工作环境应该了解什么
- Spring Controller Junit例子
- 软件维护之经验谈
- OCP-1Z0-053-V13.02-25题
- OCP-1Z0-053-V13.02-25题
- PHP数组常用函数
- Xcode 4.5.2 + iOS 6.0免证书(iDP)开发+真机调试+生成IPA(有做补充)
- ios开发之网络编程
- C# + MATLAB编程
- 【分类】行业类别一览表
- (译)KVO的内部实现[转载]
- nginx源码分析