Which statement is true about loading data using the conventional path of SQL*Loader? A.Redo is not

Which statement istrue about loading data using the conventional path of SQL*Loader?

A.Redo is notgenerated while performing conventional path loads.

B.Only PRIMARY KEY,UNIQUE KEY, and NOT NULL constraints are checked.

C.No exclusivelocks are acquired when the conventional path loads are performed.

D.Instead ofperforming transactions, SQL*Loader directly writes data blocks to the datafiles.

E.INSERT triggersare disabled before the conventional path load and reenabled at the end of the

load.

【考点分析】SQL*Loader常规路径加载和直接路径加载区别 

【题意简述】对于SQL*Loader常规路径加载描述正确的是?

【原理概念】 常规路径加载通过执行SQL INSERT语句,将数据插入到数据库中.直接路径加载通过格式化Oracle 数据块并将其直接写入数据库文件,消除了大部分Oracle DB开销.直接加载不与其他用户争用数据库资源,因此数据加载速度通常与磁盘速度相差无几.

【答案剖析】 

A: 错误,常规路径加载始终生成redo 

B: 错误,常规路径加载保证所有约束,直接路径加载保证主键,唯一性约束和非空约束 

C: 正确,常规路径加载不会加表级排它锁 

D: 错误,直接路径加载将数据写入到数据文件 

E: 错误,常规路径加载会触发trigger

最后

以上就是斯文毛豆为你收集整理的Which statement is true about loading data using the conventional path of SQL*Loader? A.Redo is not的全部内容，希望文章能够帮你解决Which statement is true about loading data using the conventional path of SQL*Loader? A.Redo is not所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。