Oracle
1Z0-052 · Question #200
Which statement is true about loading data using the conventional path of SQL*Loader?
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #200. The question stem and answer options stay visible for context.
Moving Data
Question
Which statement is true about loading data using the conventional path of SQL*Loader?
Options
- ARedo is not generated while performing conventional path loads
- BOnly PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked
- CNo exclusive locks are acquired when the conventional path loads are performed
- DInstead of performing transactions, SQL*Loader directly writes data blocks to the data files
- EINSERT triggers are disabled before the conventional path load and reenabled at the end of the load
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL*Loader#conventional path#table locks#constraint checking