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 column
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
答案:BCE
参考:https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm#i1010293
The default method that Data Pump uses for loading and unloading data is direct path, when the structure of a table allows it. Note that if the table has any columns of datatype LONG, then direct path must be used.(排除D)
Situations in Which Direct Path Load Is Not Used
A table is in a cluster(排除A)
There is an active trigger on a pre-existing table.
(B正确)
The table has encrypted columns(C正确)
A referential integrity constraint is present on a pre-existing table.(E正确)
--这里只是列出一部分,具体查看文档
最后
以上就是醉熏寒风最近收集整理的关于100.In which situations does the Oracle Data Pump use external tables and not the direct path load w的全部内容,更多相关100.In内容请搜索靠谱客的其他文章。
发表评论 取消回复