OCP-1Z0-052-V8.02-100题
来源:互联网 发布:矩阵加1 编辑:程序博客网 时间:2024/05/22 13:06
100. In which situations does the Oracle Data Pump use external tables and not the direct path load while
exporting a table? (Choose all that apply.)
A.if a table is not in a cluster
B.if a table has an active trigger
C.if a table has an encrypted
D.if a table has a column of data type LONG defined on it
E.if a table has a referential integrity constraint defined on it
Answer: BCE
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL2879
Situations in Which Direct Path Load Is Not Used
If any of the following conditions exist for a table, then Data Pump uses external tables rather than direct path to load the data for that table:
A global index on multipartition tables exists during a single-partition load. This includes object tables that are partitioned.
A domain index exists for a LOB column.
A table is in a cluster.
There is an active trigger on a preexisting table.
Fine-grained access control is enabled in insert mode on a preexisting table.
A table contains
BFILE
columns or columns of opaque types.A referential integrity constraint is present on a preexisting table.
A table contains
VARRAY
columns with an embedded opaque type.The table has encrypted columns.
The table into which data is being imported is a preexisting table and at least one of the following conditions exists:
There is an active trigger
The table is partitioned
Fine-grained access control is in insert mode
A referential integrity constraint exists
A unique index exists
Supplemental logging is enabled and the table has at least one LOB column.
The Data Pump command for the specified table used the
QUERY
,SAMPLE
, orREMAP_DATA
parameter.A table contains a column (including a
VARRAY
column) with aTIMESTAMP WITH TIME ZONE
datatype and the version of the time zone data file is different between the export and import systems.
- OCP-1Z0-052-V8.02-100题
- OCP-1Z0-052-V8.02-1题
- OCP-1Z0-052-V8.02-91题
- OCP-1Z0-052-V8.02-92题
- OCP-1Z0-052-V8.02-80题
- OCP-1Z0-052-V8.02-81题
- OCP-1Z0-052-V8.02-82题
- OCP-1Z0-052-V8.02-79题
- OCP-1Z0-052-V8.02-77题
- OCP-1Z0-052-V8.02-23题
- OCP-1Z0-052-V8.02-72题
- OCP-1Z0-052-V8.02-157题
- OCP-1Z0-052-V8.02-156题
- OCP-1Z0-052-V8.02-155题
- OCP-1Z0-052-V8.02-29题
- OCP-1Z0-052-V8.02-110题
- OCP-1Z0-052-V8.02-165题
- OCP-1Z0-052-V8.02-171题
- Socket编程介绍
- arm交叉编译 sshd服务器让外界登陆。
- Objective-C中使用NSValue、NSNull、NSNumber、NSDecimalNumber、NSData、NSMutableData 小结
- Java的String使用
- 战争迷雾4
- OCP-1Z0-052-V8.02-100题
- Java中接口的使用
- C++的对象复制构造函数与赋值操作符重载的区别小结
- 如何将错误提示框变成有 错误提示码的提示框
- lua学习之——有道词典“划词”的秘密
- AJAX工作模式、XMLHttpRequest对象、运行流程
- OC之谓词
- MySQL修改编码设置及乱码问题
- 数据挖掘中所需的概率论与数理统计知识(补充)