Which statement is true about loading data 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 reenabled at
the end of the load
For me also B it’s correct
Basically the conventional path is an array of normal Inserts. That’s why it can check for all types of constraints (checks, cross table, etc.)
C