分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
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.
给我老师的人工智能教程打call!http://blog.csdn.net/jiangjunshow
![这里写图片描述](https://i-blog.csdnimg.cn/blog_migrate/2e19ffb3303a490d20ea5d00dd397156.gif)