Oracle 1z0-497 Question Answer
Which statement is true about loading data by using the conventional path of SQL*Loader?
Redo is not generated while performing conventional path loads.
Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
No exclusive locks are acquired when the conventional path loads are performed.
Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.
TESTED 11 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved