Which statement is true about loading data by using the conventional path of SQL*Loader?

Which statement is true about loading data by using the conventional path of SQL*Loader?

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)



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Sunil Vora

Sunil Vora

Correct ans is B

Lynn

Lynn

Should be C?

sudhakar

sudhakar

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.