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