Which statement is true about loading data by using the conventional path of SQL*Loader?
A.
Redo is not generated while performing conventional path loads.
B.
Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
C.
No exclusive locks are acquired when the conventional path loads are performed.
D.
Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
E.
INSERT triggers are disabled before the conventional path load and re-enabled at the end of
the load.
Explanation:
http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SUT73/ch8.htm#data%20paths
(see direct loads, integrity constraints, and triggers)
C.
Correct ans is B
Should be C?
Correct answer would be C.
http://www.orafaq.com/wiki/SQL*Loader
yes, correct answer is C.
During conventional load, it will try to insert the data. Insert doesn’t need exclusive locks where update does need exclusive lock.